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
