98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Formatting autonumbers
Formatting autonumbers
Resolved · Medium Priority · Version 2007
Simon has attended:
Access Introduction course
Formatting autonumbers
Hi, I recall it is possible to format autonumber fields so they generate a sequence, but amended to reflect a particular table's date (e.g. Employee001, Employee002, etc).
How does one do this?
If the autonumber is for the primary key will this impact detrimentally on the database?
Thanks
Simon
RE: Formatting autonumbers
Hi Simon, thanks for your query. Yes, this is possibly and shouldn't impact detrimentally on the database. Set the primary key up as an autonumber and in the Format field property enter:
"Employer"&
That will add the Employer text onto the start of the autonumber field. Add zeroes onto the end for extra prefixes, as such:
"Employer"&0
Have a play and see how far you get. Any other questions, just let us know.
All the best,
Anthony
Tue 28 Sep 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create own ribbon tab - Access 2010a. In Access click on the File tab |