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 ?
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 ?