Results 1 to 2 of 2
  1. #1
    shabbaranks is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011

    How do I stop duplicate entries in a table from an append query?


    How do I get my append query working so it doesnt append duplicates onto an existing table? Currently if I run the append query I get multiples of the same data?


  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Dayton, OH
    You will have to create a query that finds the unique records in the first table (the unmatched query wizard should help with that) and then use that query as the basis for your append query.

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

Similar Threads

  1. append query without duplicate record
    By smahdih in forum Queries
    Replies: 5
    Last Post: 11-16-2011, 12:29 AM
  2. Problem with code to prevent duplicate entries
    By ResearchRN in forum Programming
    Replies: 5
    Last Post: 11-08-2011, 12:12 PM
  3. Replies: 1
    Last Post: 10-06-2011, 08:37 AM
  4. Replies: 2
    Last Post: 04-20-2011, 06:59 AM
  5. validation setting for duplicate entries
    By noweyout in forum Forms
    Replies: 1
    Last Post: 02-18-2011, 06:14 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