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

[anthony_hunter]

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*"


"[email protected]"

 

[anthony_hunter]

thx

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


"[email protected]"