Parameter query using In

[PHodgson]

I am trying to make an MS Query interactive based on a list of values.
The usual SQL syntax for the selection is something on the lines of:
Where Fieldname In ('Value1','Value2','Value3)
However I'm trying to make this a parameter query, so my syntax is:
Where Fieldname In (?)

When the parameter dialog opens for the value list to be entered, what should the syntax of the reponse be ?

I've tried:
Value1
on it's own, this works. However, for a list of values it does not seem to work as I must have the wrong sytax. I've tried:

'Value1','Value2'
Value1, Value2
('Value1','Value2')
etc., but none seem to work. Any ideas ?

 

[Mark W.]

The placeholder for a parameter is a scalar -- not an array. Try this...

SELECT List.Fruit, List.Qty
FROM Book1.List List
WHERE (List.Fruit=?) OR (List.Fruit=?)

 

[PHodgson]

Mark,
I understand if the number of values is known and in your example is 2, but the reason for using the In syntax was to allow multiple values to be entered at query run time, and not the same number of values each time.

 

[Mark W.]

Then I'm afraid a parameter query won't satisfy your needs.