I'm creating a db to track reports for my organization in Access 2007.  We have a unique report numbering system.  For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year.  I want to create a form to add new records to the db that automatically populates the report number with the next number.  In this case, it would be GR-50-12-003.  My plan would be to have the report number field automatically populated with the next number and the rest of the fields open to fill in.  I can do the work on the rest of the fields, but I don't know how to get past this hurdle.  I believe this is simple - and my db will be simple - but I just don't know how to do it.  Any help would be great.  Thanks.



Software/Hardware used:
Access 2007