I'm having some difficulty adding strings to an existing, functioning query. It should read where PP_Problem contains string1 or string 2 but i get syntax errors whichever way i try this.
PS using the word OR instead of a comma returns all the records without filtering any of the strings
SQL = SQL & " where [PP_Problem] like '*String1*' "
this one doesn't
SQL = SQL & " where [PP_Problem] like '*String1*' , '*String2*'"