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.
May 21, 2012 5:42 PM
May 22, 2012 2:52 PM