Go4Expert - View Single Post - re-auto numbers every year by access

apr pillai

You may use the following expression to build the yearly changing number:

Code:

x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) &  FORMAT(dcount("*","employees")+1,"00000")

Replace the Table Name Employees with your own.

apr pillai Go4Expert Member
21Feb2011,12:17
	You may use the following expression to build the yearly changing number: Code: x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) & FORMAT(dcount("","employees")+1,"00000") Replace the Table Name Employees* with your own. shabbir like this