Not Like - not working in query criteria

  • Thread starter Thread starter Jen Scott
  • Start date Start date
J

Jen Scott

I have several thousand rows of data with various values (CL, A1, A2, Null).
When I put the criteria - Not Like "CL" in the query criteria, it doesn't
return any rows (and I know there are rows that don't have "CL" in them). If
I put Is Null or Not Like "CL", it will return the blank rows. I want to
return the other values (A1, A2 and Nulls), but I can't get it to return any
records when I just say Not Like "CL" or Not In ("CL"). This should be
simple, and I'm sure I'm overlooking something....any help is appreciated!
Thanks!
 
The Like operator is used with wildcards. If you didn't want to se CLEAR and
CLEAN then Not Like "CL*" would work. Notice the * wild card.

What you want is not equal to CL or Null. Below is the syntax.

<> "CL" or Null
 
Back
Top