Exclude Multiple Values from Query (1 Viewer)

[gselliott]

I know this is probably very easy but I just can't think how to do it. I want to be able to exclude any records in my query that have certain codes (4 codes) I can get the query to work excluding only 1 but it will not work with any more. Anyone any Ideas I have tired <> "Code1" or <>"Code2" etc.

Thanks in advance

 

[namliam]

try using and... instead of or...

<> "Code1" and <> "Code2" ...

regards

 

[DawnDesM]

I used- Not In ("Code 1","Code 2","Code 3")

Good luck!