Maybe it's a anti-query

[lflopes]

I need a query that shows the "not chosen" values.

That is:
I have table with MANY entry. If I choose FEW (query parameter) how can i write a query that show SOME=MANY-FEW

Thanks

 

[123James]

no offence intended, but the description of your problem makes almost no sense to me what so ever!

 

[neileg]

If you have a list of parameters, you would usually use the IN comparator, eg, IN ("red", "blue", "green") to match records to these parameters.

Conversely you can use NOT IN, eg NOT IN ("red", "blue", "green") to find those records that don't match.

 

[Pat Hartman]

You can also use the wizard to build an "unmatched" query or create your own with a left join.

Select tbla.* from tbla left join tblb on tbla.keyfld = tblb.keyfield
where tblb.keyfield Is Null;