Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    59

    Arrow Unanswered: How to deal with autonumber in a query

    i have a insert query but i am unable to deal with the autonumber field .. what to insert in it and how
    like
    insert into jv (JVNO, DATE,SLCODE,CATEGORY,SUBCAT, clientcode, TYPE, AMOUNT, DESCRIPTION, POST)
    values ('','dlookup("DATE" , "COM")','DLookup("COMMISSION_INCOME", "SETUP")','DLookup("CATEGORY", "SETUP")',
    'DLookup("SUBCATEGORY", "SETUP")','','CR','DLOOKUP("commission","COM")','A UTO GENERATED','-1');

    jvno is autonumber.. any ideas how to deal with it

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    As its name implies, the autonumber is assigned by the system automatically. You should not include the field in your append query.
    Paul

Posting Permissions

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