Format Auto Number in MS Access 2000

Hi, I've created a database of work orders that uses the tracking number as the primary key set to autonumber. This has been working great, but now the powers to be asked me to change the tracking number to look at the year the work order is created, then add the last two numbers of the current year to the begining of the number (ex. wo# 2019 created in year 2004 would look like "04-2019")How would I change the auto number to do this, and also not lose the current wo#'? The date originated field is set to Date/Time, Short Date, 99/99/0000;0;_ and default value is Now()
Thnx, dret

you cannot format an autonumber field... this is created by, and controlled only by access. You could create another key field, and manually set this key's values yourself (or via scripts)

The primary key could be set to both autonumber and the manual key field combined!

Hope this helps.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Thanks Rob. Must be why I couldnt get it to work LOL