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.

Thanks,

Anonymous