unique record ID from a query

  • Thread starter Thread starter alecgreen
  • Start date Start date
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
 
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
 
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
*
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
running total of records in query 1
Union query producing duplicate records 7
retrieve last three characters of field 2
loop though records in a query? 5
iif statement within query 2
Add Fields from Record 1
Code Check Request - Query to find reused values 2

Back
Top