INSERT INTO & Autonumber

Results 1 to 2 of 2

Thread: INSERT INTO & Autonumber

  1. #1
    Join Date
    Dec 1969

    Default INSERT INTO & Autonumber

    I know this is probably a newbie question, but my books arent helping very much in this :(<BR>Anyway, whats the INSERT INTO syntax in order to add new records in a table? I mean, I want the autonumber Access field to assign a key value by itself... Is it possible using SQL or should I use the AddNew function always?

  2. #2
    Join Date
    Dec 1969

    Default RE: INSERT INTO & Autonumber

    If you want to have the autonumber insert itself, then just write an insert statement that includes all the fields but that one. If field1 is the autonumber then:<BR><BR>INSERT INTO table (field2, field3..) VALUES (...)<BR><BR>That will put the values into all the other fields and the autonumber will increment itself

Posting Permissions

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