Excel & MSQuery Parameters (Excel 2002)

Topic

New Reply

Hi,
I have a msquery that downloads data from our AS400 into Excel. I’m interested in utilizing the parameters in a more complex manner if it is possible. Is it possible to have a parameter for the Criteria Operator (as opposed to having a parameter defined for the Criteria Operator “Value”). Right now I have the following in the Cirteria Operator Value (the Operator is set at “is between”:
[enter the start period],[enter the end period]
I then connect the first parameter to cell A1, and the second parameter to cell A2. This way a general user can enter the period range with out having to go into the msquery itself. However, I’d like to know if I can change the Operator from “is between” to “equals” or “begins with” or any of the Operator options WITHOUT having to enter into the msquery itself. There are times where they may want a range of dates, or one date, or a list of dates, etc. Any ideas on how to achieve this concept would be greatly appreciated!
Thanks!
Lana

Reply | Quote

Replies

The only way I know to achieve that is by modifying the SQL statement, using VBA.

Reply | Quote