Exclusion Query- MS Access 2007

[arnelt]

Hi,

I have 2 tables, Table1 (has all the records) and Table2 (has records
I wish to exclude) for example. I'm looking to create a query that
will compare the 2 tables and output all records that do NOT have
matching fields. For example, Table 1 - Table 2 = Query output.

How do I do this?? I've already created a relationship joining the 2
matching fields between the 2 tables but don't know how to create the
query.

Thanks

 

[Allen Browne]

The first dialog when you create a new query has an option for:
Unmatched query wizard.

 

[arnelt]

The first dialog when you create a new query has an option for:
    Unmatched query wizard.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.









- Show quoted text -

Geez.. it was on the first screen.. don't I feel like an idiot. Thanks
for your help.