Alphanumeric Record ID in Access Table
Posted on 2013-10-25
I need to create an alphanumeric record ID for my records in my table. I need to have it set up like this:
If the combo box on my form has a value of "D" then the beginning of it should start with a "D", or if the combo box has a value of "F" then the beginning of it should start with a "F".
Then the next 2 digits should be the last 2 digits of the year, 2013 so it will be "13".
Then I need a "-".
Then a sequential numbering system for the next 4 digits. 0001
So the record id would look something like this as an example: D13-0001 and the last 4 digits would increment but when the year changes to 2014 then the 4 digit numeric will reset and start from 0001 with an example being: D14-0001.
Any ideas how I can set this up?