Posted by Erland Sommarskog on 06/10/07 07:42

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.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]