Hi, I have read each post I can find on this topic but I did not find any solution to my issue. I formed an access database (intended for volunteer work) that has an Autonumber field on the way to issue numbers to creatures taken in at our protection. My 'boss' (as well a volunteer) desires this easy Autonumber altered to a value that starts by the two figure year and after that has four digits, starting through 0001 that will increment in sequence and re-begin at 0001 through new calendar year. Thus, records will begin with 10-0001, 10-0002, and so on for this year as well as 11-0001, 11-0002 for after that year. Any help would be very much appreciated.
Bookmarks