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
 

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

Weekly Report 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Custom Number sequences 0
MS Word List Bug 0
Remove checked items from To Do lists 0
Sharepoint not capturing staff name when automation runs 0
Creating a Search using a combo box and then creating a report. 4
Need some PWA help 0

Top