Results 1 to 1 of 1
  1. #1
    NewtoIT is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2011

    Cool How do I use multiple queries in duplicate check

    I have a table(Invoice) of paid invoices to other companies. I want to ensure that no duplicate payments have been made in 300,000 plus invoices so I run separate queries using different criteria.
    1) VendNo, InvNo, InvAmtAbs, InvDate (qryDuplicates0)
    2) InvNo, InvAmtAbs, InvDate (qryDuplicates1)
    3) InvAmtAbs, InvDate (qryDuplicates2)
    4) InvNo, InvAmtAbs (qryDuplicates3)
    Since qryDuplicates0 has the most criteria, it produces the fewest answers. However those same answers appear again in qryDuplicates1, qryDuplicates2 and qryDuplicates3. And so on.

    I want to create a DuplicatesXref table where each of these queries places the ID record of the results of each query, and in another field notes which query it came from (i.e. 0, 1, 2,3). So an entry of a record that ends up from all 4 queries would look like:
    ID Pull
    ### 0123
    I would then create a query on DuplicateXref joined to Invoice to show me all records (with additional fields) in one table. After that, probably a macro to run them in sequence.
    Data cannot be deleted because it is the record of payments made. I just want to identify through review if someone was over paid.
    Any help on how to set up the queries and DuplicateXref table would be greatly appreciated!
    Last edited by NewtoIT; 03-09-2011 at 03:33 PM. Reason: forgotten info

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

Similar Threads

  1. Duplicate Check code with Run-Time error '3079'
    By viper in forum Programming
    Replies: 5
    Last Post: 10-18-2010, 10:12 AM
  2. Error check in queries
    By devesa in forum Access
    Replies: 14
    Last Post: 05-07-2010, 09:39 PM
  3. Queries Based On Check Boxes
    By Rubz in forum Queries
    Replies: 7
    Last Post: 05-07-2010, 03:46 PM
  4. Queries that Check field formats
    By mojers in forum Queries
    Replies: 3
    Last Post: 05-02-2010, 07:39 AM
  5. Check Box Values in Queries
    By Rubz in forum Queries
    Replies: 3
    Last Post: 04-16-2010, 11:26 AM

Tags for this Thread

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