How to list unmatched records?

[jason]

Senario:
I have a location table that lists our store locations.
The store # is the primary key. Every month I receive
data for all our locations, and generate reports by
location.
Problem:
When there are new locations or incorrect location numbers
on the monthly data, any location not already set up in my
location table is excluded.
HELP:
Is there a way to generate a report or query that shows
the data for the the locations that are not on the
location table?

 

[John Vinson]

Is there a way to generate a report or query that shows
the data for the the locations that are not on the
location table?

Use the "Unmatched Query Wizard" on the New Query button.

 

[ProfW7]

In "design view" of the query I simply right click on the connection between
the fields and have it list the "blanks" (unmatched) then I put "null" in
criteria for the other field and that gives me only the unmatched one. Roy,
(e-mail address removed)