Find non-matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am matching a transaction file to a master file. I have 261 records in the
transaction file and I get 258 matches. I need to know which records are the
ones that do not match.
 
Try using the Find Unmatched Query wizard to construct a query to do this. If
you can't do that, then post back with the names of your tables and the names of
the fields that you use to match them up.

Or try changing the INNER JOIN between the two tables to a Left (or perhaps
Right) Join and then set the criteria to IS NULL for the MasterFile's key field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to match positive and negative transactions 3
Update Query - Want to Update Only the First Match 4
Access Updating inventory levels 0
Data with no relationship, fall-out data from query 2
Recursive(?) Query 2
When Change In Data Add Record in Access 9
Updating and Creating Records 2
identify semi-duplicate records, and amend elements of those recor 10

Back
Top