How can I create a field (not autonumber) which automatically increments but allows me to reset its value to 1 at the start of each year?
Early last year I created a database of rescue animals in which I have, for each animal record, an autonumber animal ID (ID) and a field for year (of) which is auto completed. I also have an animal reference number (Ref) which is the one I use for our website etc. What I want is for me to be able to manually reset that reference number to 1 for the first record each year and for it to then auto increment throughout the year. I can then easily display our reference numbers as nnnn/yy.
I have been reading through a number of forums and Microsoft support pages but my knowledge of Access is still so basic that when I read suggested answers, I have no idea as to which screen and field to enter the given information. Please can anyone help? Be gentle with me please as this is my first post. Thank you.