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!!
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!!