How to do a parameter query with multiple values?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use a parameter query with multiple values? 15
How can parameter query use multiple values for same field? 1
Query prompt one column for multiple random values 1
Parameter Value in Crosstab Query 4
Parameter queries and null values 2
PARAMETER QUERY 4
Parameter Query multiple criteria help 6
Multiple parameter values 3

Top