irunergoiam
Registered User.
- Local time
- Today, 05:22
- Joined
- May 30, 2009
- Messages
- 76
I would like to use the autonumber data type (with New Values selected as Random) to create a unique identifier for temporary staff. There are two changes I wish to make to this number:
1) limit the length of the random number to numeric characters (the default is 10.
2) add a "t" prefix to distinguish this number for "temporary" staff. Is there another way other than concantenating in a query?
Thanks much for any guidance you guys might offer.
1) limit the length of the random number to numeric characters (the default is 10.
2) add a "t" prefix to distinguish this number for "temporary" staff. Is there another way other than concantenating in a query?
Thanks much for any guidance you guys might offer.