Results 1 to 5 of 5
  1. #1
    migo702000 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    4

    Question re-autonumbers 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


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I like that link Paul. Very well said.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Thanks Allan! I tweaked it a little, but Jason from the old mdbmakers.com gets the credit. When he closed that site I asked him if I could copy some of his FAQ's over to my site. That's one of them.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It made me discover another part of your site which I will explore when I have more time. Great stuff.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Year to date sum
    By jzacharias in forum Database Design
    Replies: 6
    Last Post: 09-10-2010, 10:38 AM
  2. fiscal year
    By RedGoneWILD in forum Programming
    Replies: 4
    Last Post: 08-04-2010, 01:38 PM
  3. AutoNumbers
    By remmons in forum Access
    Replies: 1
    Last Post: 01-30-2010, 01:39 PM
  4. Are text primary keys less efficient than autonumbers?
    By bar tomas in forum Database Design
    Replies: 4
    Last Post: 05-11-2009, 09:37 AM
  5. Select "autonumbers" not in sequence
    By jerry525 in forum Queries
    Replies: 5
    Last Post: 11-09-2008, 02:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums