Not Like criteria is going to drive me nuts!

[mattc66]

I have a query and a criteria of " Not Like 7" and "Not Like 8" without quotes. If I type that and or use the AND it shows just 7 and 8. If I remove one and just type Not Like 7 then it doesn't show 7. and If I just do Not Like 8 then 8s don't show. What the heck. I am using O365. I have used this in the past without the issue on different date.



The data type is a number. Its a link to data from a SQL view link.

Anyone have an idea on what I am doing wrong?

[orange]

Try
... Not yourField in (7,8)

.. Not (yourfield = 7 or yourField =8)

[davegri]

Orange is right. Drop the LIKE.
What's LIKE 7? 7 is 7. Nothing else is LIKE it.