Having trouble with OR operator in query

[JFHBIFF]

Hello everybody,

I am having trouble with this criteria on one field in a query

<>19 Or <>15 Or <>14 Or <>16 Or <>17 Or <>1 Or <>3

The query is still showing records that contain 14, 3 and 16.
Basically, I don't want to show records containing 19, 15, 14, 16, 17, 1 and 3.

Thanks

 

[boblarson]

You want AND, not OR.

<>19 AND <>15 AND <>14 AND <>16 AND <>17 AND <>1 AND <>3


But the better way is:

Not In(1,3,14,15,16,19)

 

[JFHBIFF]

Thanks for your help Bob. Works perfectly

 

[boblarson]

Glad to be able to help