Results 1 to 2 of 2
  1. #1
    Donatello is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    5

    Incrementing numbers


    In a form how do I make a numerical counter starting at 00001 and increment by 1 for each entry?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    you have an empty table with autonum counter....like tReportList_MT
    copy this to the working table name, tReportList
    (never use table_MT or you will loose the counter starting at 1)

    now run an append query to add data to tReportList. autonum counter will start a 1.

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

Similar Threads

  1. Help with incrementing a counter
    By Ben M in forum Database Design
    Replies: 4
    Last Post: 05-22-2012, 06:46 AM
  2. Incrementing Numbers
    By anastazia1117 in forum Access
    Replies: 3
    Last Post: 07-13-2011, 03:44 PM
  3. Integer not incrementing
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 01-31-2011, 02:40 PM
  4. Incrementing a field
    By Wayne311 in forum Programming
    Replies: 20
    Last Post: 01-20-2011, 06:21 PM
  5. Figure Numbers incrementing over Page Breaks
    By jezzamax in forum Reports
    Replies: 3
    Last Post: 12-19-2010, 08:05 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