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
|