filter to exclude "all containing" from the query

L

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
 
E

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
 
Top