I have a field in which I am using =DMax("[fieldname]","tablename"+1 to automatically increment the # displayed in the field. (autonumber substitute) What I would really like the field to do is: 02-####. Where 02- equals the last two digits of the current year and #### equals the auto incrementing number. I know I can manually set the Format property to "02-" to accomplish this for this year, but how do get the program to update the year on New Years Day to "03-" and thereafter??