Results 1 to 3 of 3
  1. #1
    SlowPoke is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    11

    append query help

    I have a table that I want to add a new record to from another table. I'm working on an append query. I have input parameters to select the record I want, but my problem is when I re-run the query I append the same record again. Yes I could not re-enter the same parameters, but I want the DB to keep track of this. I don't want duplicate records in the destination table. Any advise on how to keep this from happening?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    create unique index to advoid duplica records.

  3. #3
    SlowPoke is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    11

    Solved

    Thanks this works.

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

Similar Threads

  1. append query
    By w_kenny in forum Access
    Replies: 2
    Last Post: 08-24-2010, 05:48 AM
  2. Append Query (Maybe VBA?)
    By justinwright in forum Queries
    Replies: 14
    Last Post: 07-21-2010, 10:31 AM
  3. Append query won't append
    By yelkenli in forum Queries
    Replies: 5
    Last Post: 02-12-2010, 11:19 AM
  4. Append Query
    By aabh in forum Queries
    Replies: 6
    Last Post: 02-02-2010, 04:26 PM
  5. Append Query
    By cotri in forum Queries
    Replies: 1
    Last Post: 01-28-2010, 08:52 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