Results 1 to 3 of 3
  1. #1
    ggrams is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2014
    Posts
    2

    Automatic numbering


    I am trying to create a form that creates an automatic identifier with a value one greater than the previous identifier. I was able to create something that updates in batches of two: That is, I end up with identifiers that go 1, 2, 2, 3, 3, 4, 4, etc. How do I get it to create consecutive identifiers (1, 2, 3, 4, etc.)?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What have you tried? What are you using now?

    Here is one method: http://baldyweb.com/CustomAutonumber.htm
    The DMax at the bottom would work for you, and you don't even need a criteria.

    Creating custom unique ID is common topic. Search forum or google.

  3. #3
    ggrams is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2014
    Posts
    2
    Thank you so much. I will try this.

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

Similar Threads

  1. Invoice Numbering
    By Gatorjunkie in forum Access
    Replies: 1
    Last Post: 03-20-2014, 11:57 PM
  2. numbering a table
    By mikichi in forum Access
    Replies: 6
    Last Post: 01-29-2014, 10:10 AM
  3. Help with numbering
    By hudsonp in forum Access
    Replies: 3
    Last Post: 11-21-2012, 08:55 AM
  4. Help with Sequential Numbering
    By orion in forum Programming
    Replies: 3
    Last Post: 07-06-2009, 01:41 PM
  5. Numbering records
    By knightjp in forum Database Design
    Replies: 0
    Last Post: 08-17-2008, 07:07 AM

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