Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter/Criteria option not available for External Data Query
Hi,
I have written a query in Excel which extracts data from an MS SQL database and would like to add a date retriction as a parameter so that not all rows are returned. Unfortunately though, the parameter option is greyed out. I am even unable to add the parameter manually to the SQL query. Does this have something to do with the complexity of the query? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter/Criteria option not available for External Data Query
Display the criteria pane View--Criteria
Select a field and in the Value field type a parameter name in square brackets like [parm1]. You can then select View-- parameters For help look ínto the MS Query help for "parameter" and then "create a new query" and then "create a parameter query". When you leave MS Query on the next dialogue you can select "Paremeters" and define "how a parameter value is obtained" which lets you e.g. select a value from a cell on your worksheet. Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter/Criteria option not available for External Data Quer
thanks Hans, but unfortnately the Criteria option is not available
"flummi" wrote: Display the criteria pane View--Criteria Select a field and in the Value field type a parameter name in square brackets like [parm1]. You can then select View-- parameters For help look Ă*nto the MS Query help for "parameter" and then "create a new query" and then "create a parameter query". When you leave MS Query on the next dialogue you can select "Paremeters" and define "how a parameter value is obtained" which lets you e.g. select a value from a cell on your worksheet. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Formula Help | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) |