Delete exclusion data from original query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question about how do I eliminate data from a query. I have 7 tables that I’m pulling information from. 1 of those table is and exclusion table. If we find matching data from my original query in the exclusion table, I am to eliminate it from my report. How do I do this. Do I use a subquery?
 
I have a question about how do I eliminate data from a query. I have 7 tables that I’m pulling information from. 1 of those table is and exclusion table. If we find matching data from my original query in the exclusion table, I am to eliminate it from my report. How do I do this. Do I use a subquery?
Click to expand...

A "Frustrated Outer Join" query - which the "Unmatched Query Wizard"
will build for you - is the best bet in this case.

Join the "exclude" table to your Query; select the join line and
choose option 2 - "show all data in <your main table> and matching
records in <exclude table>". Select *only* the joining field from the
Exclude table, and put a criterion on it of

IS NULL

This will accept only those main-table records which do *not* have a
matching record.
 
Back
Top