Unanswered: How Can I Get An Unlimited Number of Criterias in my SQL?
Dear Sir or Madam,
Hello. I am helping someone to design the database system. I can't tell what it is about because it is confidential in our business. However, I can show the portion of my SQL with false names and explain the problem to you.
"WHERE (([Table].[Field] Like "*" & [Enter First Value] & "*") OR ([Table].[Field] Like "*" & [Enter Second Value] & "*") OR ([Table].[Field] Like "*" & [Enter Third Value] & "*"))"
A user would like to pull data with three values for this field. However, someone asked me, "Is it possible to have an unlimited number of criterias in this query?" I did not know the answer... I wonder if you might know the solution.