Parameter Queries

  • Thread starter Thread starter Chris
  • Start date Start date
C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Parameter Query 1
Parameter Query Won't Run 0
Parameter Value error in a Subform 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Query Parameter using multiple options 0
Data Validation - Complex Q 2
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Can't create a report from my query in Access 1

Back
Top