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.
 
Back
Top