Not In Query

  • Thread starter Dave - MS Newsgroups
  • Start date
D

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
 
R

Robert_DubYa

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
 
D

Dave - MS Newsgroups

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

Dave
 
Top