Not like * wildcard not working

C

Cam

Hello,

I am inputing the not like function in Microsoft query and it is not
filtering out the data.

I use (Not Like '*MRB*') on a text field. What should I use to filter out
all records that exclude a word MRB in a text field? Thanks
 
J

John W. Vinson

Hello,

I am inputing the not like function in Microsoft query and it is not
filtering out the data.

I use (Not Like '*MRB*') on a text field. What should I use to filter out
all records that exclude a word MRB in a text field? Thanks
Click to expand...

There is a double negative in your request, and I'm not sure I understand what
you want. You say "filter out all records that exclude a word" - do you mean
that you want to show all records which DO NOT have "MRB" somewhere in the
field? or do you want to EXCLUDE those records which DO NOT have "MRB"?
 
Top