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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
New computer, how do i move outlook 365 ENTIRELY? 0
MS Outlook inbox to MS Accsess Database 0
Create custom autonumber field 5
Creating Field With combo of autonumber and text 3
Autonumber associated with date 0
custom autonumber 2
Errors in Autonumber ID field 4

Top