How to autonumber in Access

[jmk2z]

I'm trying to get the primary key in an Access table to autonumber in the following manner:

D030001
D030002
D030003
D030004
etc.

Where 03 represents the year 2003 (next year it would be 04). Is there a way to get it to do this?

Note: the year part is less important than the numbering on the right side.

 

[Pennanti]

In the Format of the values for that column type "D03"00000 with the quote marks and as many zeros as you want numbers. The text in the quotes is entered written and the zeros act as number place holders that are incremented automatically by the autonumber.