Enzo has attended:
Visio Introduction course
Excel Advanced course
Creating random unique numbers in access
How can I auto create unuique and random reference number for records so that they are all different.
RE: Creating random unique numbers in access
Hi Enzo
As we saw on the training you can use an Autonumber field (named ID for example) and change the New Values property from Increment to Random. This produces a 10 figure random number.
As half of these numbers will be negative you can create a separate calculated field instead with the Abs function. This will make all the numbers positive.
Abs([ID])
To create a shorter number you could use
Abs(Left([ID],5))
This will create a random 5 figure number.
Doug Dunn
Best STL
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
