How to do a parameter query with multiple values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is is possible to have a parameter query where the user enters multiple
values for a field? Example: a large database contains a field called
"ClassCode". The user sometimes wants to see ClassCodes of "JSB", "JSC", or
"JGS" ... or any other number of values; or even all values?

I can get it to work for one value by simply typing [ClassCodeSelection] in
the criteria field. But how do you handle multiple values? I have tried
"IN", but must not have correct syntax because nothing is returned.

Thanks for the help!!
 
Back
Top