Unanswered: Access 2003, generating ID codes -autonumber?
how do I generate product codes that automatically detects the current year and can do auto-letters? specifically:
(YY)-(#####)-(A) : where YY is the last two digits of the current year, ##### is an autonumber that starts from 00001. Oh, and I can't seem to make it display zeroes before an integer. ...and A is an ...uhm "auto letter" that starts from letter A and ends with Z
Is it possible for access to generate it automatically whenever I add a new entry? I'm manually inputting every code at the moment.