MS Access 2003 (Create an Alphanumeric Autonumbered Field)

S

slblakley

I need to create an autonumbered field in my access 2003 database that
looks like the following:
DCR-07-000

The DCR is a constant, the 07 is the year and will need to update as
the year changes and the 000 is sequential.

Any help would be awesome!! Thanks so much!!!
 
Top