re-auto numbers every year by access
View Single Post
You may use the following expression to build the yearly changing number:
x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) & FORMAT(dcount("*","employees")+1,"00000")
Replace the Table Name
with your own.