re-auto numbers every year by access

migo702000's Avatar, Join Date: May 2010
Newbie Member
My question is how to configure the automatic numbering perception Next
IAZR-14-AUG-10-0001
Where the first part is the fixed code
Part II on today's date as the manual described
The third part is automatic numbering which was increasing with the addition of each new record
With a very pertinent observation
Is that because the numbering of the beginning of (1), the first of each calendar year
Enclose with an illustration of the solution
Thank you very much
apr pillai's Avatar, Join Date: Dec 2010
Go4Expert Member
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