I am trying to get a query with 5 parameters to work in Excel. The query works correctly when I hard code the parameters, but as soon as I modify the query to prompt for parameters it duplicates the number of parameters. Instead of asking for the 5 parameters, it asks for 10. If I enter each parameter twice I get the desired results. I can successfully get it to work up to 3 parameters, when I add the 4th parameter it begins to double the number of parameters. Has anyone run across this before, or can anyone offer some intelligent things to try. It looks like a bug to me, but there may be a trick or two I don't know. Thanks, Kathie
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel MS query parameters
- Thread starter kclose
- Start date