Generate automatic report number in Access 2007

5 pts.
Tags:
Microsoft Access 2007
Microsoft Access reports
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following