Forum home » Delegate support and help forum » Microsoft Access Training and help » Formatting autonumbers
|
|
|
The UK's most regular 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. |
Formatting autonumbers
Resolved · Medium Priority · Version 2007
Reply Mon 20 Sep 2010, 12:31Delegate Simon said...
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
For upcoming training course dates see: Pricing & availability
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.
|