How to list unmatched records?

  • Thread starter Thread starter jason
  • Start date Start date
J

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?
 
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?
Click to expand...

Use the "Unmatched Query Wizard" on the New Query button.
 
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)
 
Back
Top