Multiple search values and parameterised query

C

Charles Tam

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
 
M

[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.
 
D

Duane Hookom

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