Not In Query

[Dave - MS Newsgroups]

I have a table that contains available options for house construction. I
have another table which contains the options desired on a certain house. I
need a query that will show me all the available options not in the table
containing selected options. Is there a way to do this?

Thanks.

Dave

 

[Guest]

The easiest way would be to use the query wizard. Click on new query and at
the bottom of the list it will say "Find Unmatched Query Wizard". Let it
lead you through the wizard. If this gives you the results you are looking
for give the design view a look for future reference.

RW

 

[Dave - MS Newsgroups]

Don't know how I forgot about that wizard. Thanks. Works like a champ.

Dave