filter to exclude "all containing" from the query

  • Thread starter Thread starter Leo Rod
  • Start date Start date
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
 
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
 
Back
Top