Using "not" criteria

  • Thread starter Thread starter Karin
  • Start date Start date
K

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
 
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.
 
Make this your where clause:
WHERE ((Not ([YourField])="ABC")) OR ((([YourField]) Is Null));
 
Thank you. I had one of those "Duh" moments.
-----Original Message-----
Make this your where clause:
WHERE ((Not ([YourField])="ABC")) OR ((([YourField]) Is Null));

Karin said:
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.
Click to expand...


.
Click to expand...
 
Back
Top