Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    20

    Question Unanswered: Autonumber and make table

    Okay, how can i make a table and have an autonumber field be created?

    OR even in a select query for that matter?

    I have a phone list:
    [name] [dept] [cell] [pager]

    so i want to select name, dept, cell, pager and id: Autonumber.

    is this possible? I figure so. If you can Count, Sum, etc. you must be able to have an incrementing function.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    http://www.mvps.org/access/tables/tbl0016.htm

    Create a temp table with a modification to the the code listed in the above link.

    Append your data into the temp table and then select it.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •