Exclusion Query- MS Access 2007

A

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
 
A

Allen Browne

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top