MS Query Question

Posted by Geoff Remmler on July 18, 2001 7:06 AM

Is there a way to pass a parameter to a MSQuery without having to go in and edit the query? I want to have a generic query that can be configured by the user by selecting dates, models, states, etc. that he is interested in before the query is run. Most of my users aren't capable of editing the query, so I get asked to change dates, SKUs, etc. a lot. I would like to write the query with "variables" that can be selected by the user whenever they press the REFRESH button. Is this possible without a lot of VBA coding?

Posted by Mark W. on July 18, 2001 7:14 AM

Yes, see the MS Query Help topic for "Create
a parameter query". Also, see the Excel Help
topics for "Create a query that prompts for
criteria", "Change the custom prompt for a
parameter query in Excel", and "Use data from
a cell on a worksheet as a parameter value".