Re: Not In Query

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

Dave

"Robert_DubYa" <RobertDubYa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C6559EC-BB19-45C0-855B-738FC82533F6@xxxxxxxxxxxxxxxx
> 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" wrote:
>
>> 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
>>
>>
>>


.