Multiple search values and parameterised query

[Guest]

Dear Access Users,

How do I input multiple search values into a parameterised SELECT query?
For example, I would like retrieve records that matches a list of values
provided by the user.

Kind Regards
Charles

 

[[MVP] S.Clark]

a single parameter in a query can only accept a single entry. IOW, you cant
have a city prompt and enter "Dayton, Cleveland, Akron"

If you want to have multiple parameters, then just add them to the grid as
needed.

 

[Duane Hookom]

Or you could kludge this with
SELECT TableA.*
FROM TableA
WHERE Instr("," & [Enter Cities separated by commas with no spaces] & ",",
"," & [CityField] & ",")>0;