How do I do an unmatched query where I only compare information i.

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

Guest

I have a query that I created that has a lot of client level data. I want to
be able to create an unmatched or duplicates query that automatically shows
me which fields do not match up and which fields do. The problem is that it
keeps pulling no data. If I specify only one field, it works fine. But I
need additional information in the query in order to accomplish my goal.
 
You are asking two things - unmatched or duplicates.

Unmatched means two tables and Duplicates multiple copies of the same record
in the same table.

Are you talking about one or two tables?

The query wizard will give you unmatched. Once you have a list of records
that do not match then use that query joined to your tables in a second query
 
Back
Top