Posted by Bob Quintal on 06/10/07 11:12

Erland Sommarskog <esquel@sommarskog.se> wrote in
news:Xns994B62FEC60E1Yazorman@127.0.0.1:

> Bob Quintal (rquintal@sPAmpatico.ca) writes:
>> Erland Sommarskog <esquel@sommarskog.se> wrote in
>> news:Xns994AD933293B9Yazorman@127.0.0.1:
>>> chico_yallin@yahoo.com (chico_yallin@yahoo.com) writes:
>>>> I just wana make a random id number based on4 digits-for
>>>> examples??
>>>
>>> checksum(newid()) is better than the rand() function.
>>
>> Please provide instructions on the use of these functions in
>> MS- Access using the Jet engine.
>
> Sorry, I did not notice that the thread was cross-posted
> between the SQL Server and Access newsgroups. I assumed that
> since you posted in a newsgroup for SQL Server, you wanted a
> solution for SQL Server. I have no idea what might work in
> Access.
>
I didn't notice the cross-post either, and I don't know wether
your solutin would be acceptable to the original poster. I sure
would like the functionality of newid() in Access.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Back to original message]