I would like to create a sql statement that looks something like:
select *
from myTable
where myTable.ItemID in ([Parameter])
Actually, I'm passing these values to a stored procedure using Visual Basic but I can't even get this to work from the Access Query Designer.
I want to be able to supply a list of IDs (i.e., long integers) but Access treats the parameter as having a single value contained in it. Comma separation doesn't do anything.
I'd like to avoid using string parsing functions like Instr() and just take advantage of the "in" operator.
Am I doing something wrong or is this impossible.
Thanks,
Ken