Using "not" criteria

[Karin]

I want to return all records that do not have "ABC" in the
company field. Using "not 'ABC'" also eliminates records
which have no data in the company field.

How do I create a query that doesn't return ABC, but does
return null and all other records.

Thank you,
Karin

 

[Lillian]

Karin:
You need to use "not like 'ABC*'"

Hopefully, that will work.

Lillian

 

[Karin]

Unfortunately, that gives me the same records. (ABC, in
this instance, would not need "*'s" as it is the entire
string in that field.)
Thank you for responding.

 

[John Verhagen]

Make this your where clause:
WHERE ((Not ([YourField])="ABC")) OR ((([YourField]) Is Null));

 

[Karin]

Thank you. I had one of those "Duh" moments.

-----Original Message-----
Make this your where clause:
WHERE ((Not ([YourField])="ABC")) OR ((([YourField]) Is Null));

Unfortunately, that gives me the same records. (ABC, in
this instance, would not need "*'s" as it is the entire
string in that field.)
Thank you for responding.

.