Use two separate fields, one for YYMM value and other for ### value. Make
the two fields a composite primary key so that unique values of the two
fields in combination will be required. You can then handle the
incrementation of the ### field using widely available code that involves
the DMax function.
You then can concatenate the two fields with the - character in queries for
display on forms and reports.
<MS ACCESS MVP>
"Pat" wrote in message
>I am trying to create a reporting program for our Public Safety Department
> and they want the records to be automatically numbered using the format
> YYMM-### (Example: first report for the month of Sept. 2006 would be
> then 0609-002. etc. and then in October 2006 it would be 0610-001).
> Is this possible and if so, can you tell me how?
> IT Trainer