1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

re-auto numbers every year by access

Discussion in 'MS Access' started by migo702000, Sep 20, 2010.

  1. migo702000

    migo702000 New Member

    Joined:
    May 29, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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:
     
  2. apr pillai

    apr pillai New Member

    Joined:
    Dec 17, 2010
    Messages:
    16
    Likes Received:
    12
    Trophy Points:
    0
    Occupation:
    Auditor
    Location:
    India
    Home Page:
    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 likes this.

Share This Page