Parameter Queries

[Chris]

I have a basic query that I've set up in Excel, using
Microsoft Query, that uses a parameter (state) that is
stored in another cell. I can't figure out how to have
multiple values in the cell though, or even if that is
possible. Does anyone know how to get around having just
the one value?

 

[Don Guillett]

You need to give us much more info including copy/paste of the url used.
Generally, you can do this with
xxxxxxparameterxxxxxxx
xxxxxx&[a1]&xxxxxxxxx
or
"xxxxxx" & [a1] & "xxxxxxxxx"