Report the excludes items in a table

J

JeffH

I have a complete list of payers by Tax Identification Number (TIN). I also
have a subset of this list. What I want is a report that will give me a list
of payers in the complete list that are not in the subset list. How can I
accomplish this?

Thanks.
 
K

KARL DEWEY

In query design view put both tables in the space above the grid.
Click on the TIN field in the complete list table and drag to the other
table TIN field.
Double click on the line that connect the two tables and select "Include ALL
records from 'CompleteTable' and only those records from 'ShortList' where
the joined fields are equal."
Pull down the TIN field from shortlist table and use criteria -- Is Null
 
Top