Not Like - not working in query criteria

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!
 
J

Jerry Whittle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Copy Data from one worksheet to another 1
help with query for report 1
Running Total in Access 2002 2
Worksheet Change event not running a macro 10
Summarizing with multiple conditions - Formula solution needed 2
Criteria from Form 3
Query Criteria 1
Range parameter on different sheet not working? 2

Top