Hello from another beginner:





I have a similar situation as described here with a bit of a different twist.





I need to generate an auto number that resets at the beginning of each year,
but that
also incorporates the last 3 digits of the year in the number.
Example: 004-001, 004-002, 004-003.....004-098. And now that it is 2005, I
need it to start 005-001, 005-002, 005-003...etc.





How do I set up a field with an autonumber such as this (if it is possible?)
and where do I place such code?





Any help would be greatly appreciated.



Use exactly the same approach and continue to use TWO fields for storage. For
display you can use...

Format(RecordDate, "\0yy-") & Format(RecordID, "000")



Thank you so much. The database is at work, so I will try implementing it tomorrow.
Gratefully, Linda