unique record ID from a query

A

alecgreen

It is possible to create a uniques record ID from a query alone, or
does it have to be generated from a table??

Many Thanks

Alec
 
B

Barry Gilbert

The autonumber field in a table generates a long value. There is no way to do
this natively in a query. However, you can generate a GUID in a query by
calling a function, like this ones in this module:
http://www.trigeminal.com/code/guids.bas

It really depends on what you want to do with it.

Barry
 
S

strive4peace

Hi Alec,

Every table should have an autonumber ID field (in my opinion). That
said, there is no need to use a query to generate a unique number...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top