I'm trying to create an auto incrementing custom id in Access without using autonumbering. Our job tracking number resets to 0000 at the beginning of every year and the year prefix changes accordingly as well. ie. 01-9999 to 02-0000. How do I create an auto incrementing id? I should also mention that I'm working with an existing table that has job tracking numbers in it already that use the autonumber feature. Since I can't reset an autonumber I'll need to implement the new method seemlessly.
Chandler
I ran over my dogma with karma!
Chandler
I ran over my dogma with karma!