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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!