Exclusion Query problem?

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have two tables, one with all the data and one with only certain lines, all
of those being on the main table. How does one make a query to ONLY show the
lines that are NOT on that second table.
 
Don said:
I have two tables, one with all the data and one with only certain lines, all
of those being on the main table. How does one make a query to ONLY show the
lines that are NOT on that second table.
Click to expand...


Try creating a new query using the Unmatched query wizard to
see how this is done.
 
Create a query in design view, placing both tables in the space above the
grid. Position the main table (the one with the most) on the left and other
on the right.
Click on the field(s) of the main table that makes the records unique and
drag to the corresponding field(s) of the other table. Double click the
connecting line(s) and select the option to show all records of main table
and only those of other that match.
Drag the field(s) connected in the other table down to the Field row of the
grid. Click the check box to turn off display. In the criteria row of the
field(s) connected in the other table enter Null for each on same
row.
This will pull records of main table that do not appear in the other table.
 
Back
Top