Query Question

[BuzzG]

I have a query in Excel that gets data from an Access query. The Access query has a criteria parameter that prompts the user to enter a critera. When I run the query from Excel, it does not let me enter the critera. Instead I get an error msg "Too Few Parameters. Expected 1". Do I have to clear the parameter in the Access query and then use the filtering in Excel (Query Wizard) to get my results or is there a way to get the user prompt when running the Excel query?
BuzzG

 

[thelton]

You didn't post what you had for a query, are you using MSQuery or an SQl statement?if using MSQuery are you using the square brackets [] to specify user input?

 

[Mark W.]

See the Excel Help topic for "Create a query that prompts for criteria".

 

[BuzzG]

I'm using MSQuery. Once I select my database in launches right into query wizard. How do I avoid the wizard?
I'm running MS Office 97 Pro with XP.
BuzzG

 

[Mark W.]

On the Choose Data Source dialog... uncheck the "Use the Query Wizard..." option.

 

[BuzzG]

Thanks Mark. That worked fine.
BuzzG