How can parameter query use multiple values for same field?

[Guest]

Is it possible to have parameter query that uses multiple values?

Example: a large database contains a field named "ClassCode". The user
wants to specify any number of values for this field (like "JSB", "JSC",
"JGS") or retrieve all records.

The only parameter query that I get to work only returns 1 value. Is it
possible to retrieve multiple values? If so, what is the syntax?

Thank You!

 

[Michel Walsh]

Hi,


You can fill a temporary table

Temp ' table name
f1 ' field
'JSB*'
'JSC*'
'JGS*' ' data sample


SELECT ...
FROM TableA INNER JOIN Temp
ON TableA.FieldName LIKE Temp.f1



Hoping it may help,
Vanderghast, Access MVP