Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   re-auto numbers every year by access (http://www.go4expert.com/forums/auto-year-access-t23365/)

migo702000 20Sep2010 20:29

re-auto numbers every year by access
 
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
:confused::confused::confused:

apr pillai 21Feb2011 12:17

Re: re-auto numbers every year by access
 
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.


All times are GMT +5.5. The time now is 10:48.