Hi All,
I am relatively new at programming access but am familiar with most things. I am having a problem with a field I need. I have to have a field that contains the year (4 digits) and an auto number (000) that needs to be "zero" ed out at the beginning of the new year i.e. (2009-015 to 1010-001). Can this be done and How. I am using Access 2003 not 2010.
rkski