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
does it have to be generated from a table??
Many Thanks
Alec
G
Guest
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
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
*
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
*