I am attempting to develop an Access database to track reports and paperwork. All these documents have a unique report number attached in the form of the year-## (example: 2001-15, 2001-16, etc.)
In addition, when we enter a new year, the number reverts back to 1 (example 2002-1, 2003-1, etc.)
I read about the use of a query in another post, but could not get it to work as I had hoped. My question is this: is there any way to write a control or script that will automatically assign the report number in the format that I need, increasing by one for each new record and when the year changes, updates the year and reverts to 1?
All that clear as mud? As a favor, if you can help, please explain as you would to a child. I'm still learning my way. Thank-you!!!
In addition, when we enter a new year, the number reverts back to 1 (example 2002-1, 2003-1, etc.)
I read about the use of a query in another post, but could not get it to work as I had hoped. My question is this: is there any way to write a control or script that will automatically assign the report number in the format that I need, increasing by one for each new record and when the year changes, updates the year and reverts to 1?
All that clear as mud? As a favor, if you can help, please explain as you would to a child. I'm still learning my way. Thank-you!!!
