Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple parameters in MS Query
Hi!
I created a Microsoft query in Excel to pull some data from our accounting database. I use [Enter Job Number] as the parameter, so it will ask me to enter one job number every time I run it. Instead of one job number, how can make the query to prompt me to enter multiple parameters/job numbers? I know I can use "Add Criteria" in "Edit" mode to enter more parameters. However, it is not quite convenient. Thank you very much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple parameters in MS Query
On separate rows in MS Query, you can enter parameters, e.g.
[Enter Job #1] [Enter Job #2] [Enter Job #3] Then, select a cell in the external data range, and on the External Data toolbar, click the Query Parameters button. Select each parameter from the list, and link it to a worksheet cell, with refresh automatically enabled. Ken wrote: Hi! I created a Microsoft query in Excel to pull some data from our accounting database. I use [Enter Job Number] as the parameter, so it will ask me to enter one job number every time I run it. Instead of one job number, how can make the query to prompt me to enter multiple parameters/job numbers? I know I can use "Add Criteria" in "Edit" mode to enter more parameters. However, it is not quite convenient. Thank you very much! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF function query for multiple colums | Excel Worksheet Functions | |||
Another Multiple Conditions Query | Excel Worksheet Functions | |||
query multiple excel files | Excel Discussion (Misc queries) | |||
Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) |