exclude multiple values in query

[mdemarte]

I tried looking up Exclude data, but did not find what I need. I need to exclude pieces of equipment where the model equals snowmobile, or starts with atv or has the word trailer in it. Here is the query that I have created. Why doesn't it work?

SELECT tblADMEQUIP.MODEL
FROM tblADMEQUIP
WHERE (((tblADMEQUIP.MODEL)<>"snowmobile" And (tblADMEQUIP.MODEL)<>"atv*" And (tblADMEQUIP.MODEL)<>"*trailer*"));

 

[Jon K]

Try this:-

SELECT MODEL
FROM tblADMEQUIP
WHERE MODEL <>"snowmobile" and MODEL not like "atv*" and MODEL not like "*trailer*";

 

[mdemarte]

AWESOME! It looks like it should do the same thing, but that worked!