Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Random AutoNumber
- Thread starter randaj
- Start date
Hi
If your prefix is always 'R', just add it when you display the number you can do this with concatinate or format so
= "R" & MyAutonumber
= "R" & FORMAT(MyAutonumber,"0000000000"
If the prefix is variable, save the prefix in a seperate column in the table, and again present the output as one number using concatination as described above.
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
If your prefix is always 'R', just add it when you display the number you can do this with concatinate or format so
= "R" & MyAutonumber
= "R" & FORMAT(MyAutonumber,"0000000000"
If the prefix is variable, save the prefix in a seperate column in the table, and again present the output as one number using concatination as described above.
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question