Query filter for text field: Not Like "MEX" or Not Like "CAN" doe.

[Guest]

When trying to setup a filter of a text field I don't get the results I want.
Is Not Like a proper key word for a query filter in access? If not, what
the filter command be?

 

[Edward G]

try
not like "Can*" and not like "Mex*"


"(e-mail address removed)"

 

[Guest]

thx

try
not like "Can*" and not like "Mex*"


"(e-mail address removed)"