Results 1 to 2 of 2
  1. #1
    Allen is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    1

    Numbering Access ID column


    I have a database with approx. 2000 rows and 5 colums. Recently while messing with it and trying to do something 'clever' I deleted the ID column numbers. The question - how can I replace these.

    Thanks,

    Allen

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    Create a new field called <MyTablename>ID, datatype numeric, autonumber.

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

Similar Threads

  1. Page numbering
    By gumberculies in forum Reports
    Replies: 1
    Last Post: 04-11-2011, 02:21 PM
  2. numbering line entries
    By tgavin in forum Access
    Replies: 6
    Last Post: 07-27-2010, 11:53 AM
  3. Help with Sequential Numbering
    By orion in forum Programming
    Replies: 3
    Last Post: 07-06-2009, 01:41 PM
  4. Numbering records
    By knightjp in forum Database Design
    Replies: 0
    Last Post: 08-17-2008, 07:07 AM
  5. Auto Numbering
    By rkruczk in forum Forms
    Replies: 0
    Last Post: 10-09-2006, 04:25 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