Excel Query Criteria

[spg2112]

Hello all,

I'm using the MS query in Excel and instead of using the criteria filters in MS Query I'd rather use Excel combo boxes, drop downs etc. Is there a way to populate the criteria filters in MS query from a control box?

[lenze]

If you use design mode to create or edit your query, you can include a parameter to be prompted for on refresh. You can then go to parameter options and link the parameter to a cell. You will have the option to select automaticcaly refresh when this cell changes. Use a combo box or data validation to populate this cell

[spg2112]

The only thing I see in parameter options is to change the name of the parameter. Am I looking in the right place?

[Mark W.]

On 2002-04-26 07:56, spg2112 wrote:
The only thing I see in parameter options is to change the name of the parameter. Am I looking in the right place?

Here's an example of a parameter query that prompts for a value...

SELECT Table1.Customer
FROM Book2.Table1 Table1
WHERE (Table1.Call_Date=?)

You can then configure the external data range to accept a parameter value from a worksheet cell. See the Excel Help Index topics for...

1. Create a query that prompts for criteria
2. Use data from a cell on a worksheet as a parameter value

[lenze]

After you return to Excel from MS query. right click on the date and choose parameters. A dialog box will open with the parameter options

[spg2112]

That will work! Thanks guys! This board rocks.

Steve