Not like * wildcard not working

[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

 

[KARL DEWEY]

Post the SQL of your query.

 

[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

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