query criteria for multiple NOT LIKE statements

[gordytech]

i am trying to create a query that does NOT show records with four different text strings. The text strings are not consistently written, so i have to use wildcards as well; for instance - - - - not like "*abc1 & "*" works fine but when i try to insert more than one it doesn't work - - - - supposedly, this works NOT LIKE ("*abc1" & "*","*ef5" & "*","*mn7" & "*","*S/S" & "*") but it doesn't

 

[Joe4]

Welcome to the Board!

I think you need to list each one out individually, i.e.

NOT LIKE (condition1) AND NOTE LIKE (condition2) AND NOTE LIKE (condition3) AND NOTE LIKE (condition4)

 

[gordytech]

thanks, I will try that

 

[gordytech]

I get an error message that says "Data Type Mismatch in criteria expression"

 

[james_lankford]

select 
  *
from 
  tbl 
where 
(
  (
    field_1 NOT LIKE '*abc1*' 
  )
  and
  (
    field_1 NOT LIKE '*ef5*' 
  )
  and 
  (
    field_1 NOT LIKE '*S/S*' 
  )
)