filter to exclude "all containing" from the query

[Leo Rod]

Good afternoon,

I need help; when trying to exclude all the records that contain an specific
combination of letters: "TRF", even when I'm able to do it in Microsoft SQL,
I can't find a way to make it work in access.

Can somebody help me with this "wildcard" to select and exclude all lines
with "TRF"?

Thanks in advance and greetings,

Leo
Mia-USA

 

[Ed Robichaud]

If you can do it in SQL, you can do it in Access. Switch your query design
view to SQL and use the same command line.

In design grid mode, the criteria would look something like:
"<> Like(*TRF*)

-Ed

 

[Douglas J. Steele]

Actually, it would be

Not Like "*TRF*"

 

[Ed Robichaud]

Oops! right you are.

Actually, it would be

Not Like "*TRF*"