Hi!
I am very new to access so first of all, I would like to apologize if I talk utter nonsense!
I would like to create a field that appears on both a form and the main table my form is linked to. I need this unique ID to automatically generate for every new record. The ID needs to be the last 2 numbers of the current year followed by a 4 digit sequential number (YY-0000) so 17-0001, 17-0002 then 18-0001. I need this number to reset at the start of each year.
I have read what seems like hundreds of forum threads in the general area but I have not found anything that has worked for my particular needs.
I would greatly appreciate any help! I would prefer if possible an alternative to VBA as like access I am brand new to it but I am open to options!
Thank you in Advance!
Kerry