how to remove specific values within my critera (in design view)

[eeps24]

For example, lets say I want to query a bowl of fruit but I don't want results that have apple, oranges, pears. Lets say there's 100 types of fruit. How do I tell ms access to ignore apple, oranges and pears in my search? Im using the design view in access.

Thank you

[ItsMe]

In Access you can use the = symbol to equate. Another operator is >.

If you want to find something that is not equal to something else you could use an expression like ...
<>"Apple"

[June7]

For multiple parameters on same field, look at IN and NOT IN operators.

SELECT * FROM table WHERE [fieldname] NOT IN ("apple", "orange", "pear");

[eeps24]

thank you both!