Pivot Table from Access

2077delta · Mar 28th, 2002, 11:23 AM

I would like to create a pivot table from a query in Access. However when I connect to the query through the wizard, it won't let me run the query. If I try to run the query I just get a beep, no error message. If I try to add a filed from the Access query to MS Query I get an error message that reads "Too few parameters. Expect 1". My Access query is actually a summary query of another query that retreives the detail data I need for the summary. In addition the detail query in Access has one parameter it prompts the user for. Is this type of query unusable for MS Query? Can I build a multi-level query in MS Query like the one I have in Access (although I hate to duplicate the effort)? Is it better to bypass MS Query and use VBA in some way to connect to the tables or Access query and run the query?

Russell Hauf · Mar 28th, 2002, 01:35 PM

The parameter in the query is what's causing your problem. You could use VBA to set up your pivot table, and could use an InputBox to ask the user for the parameter value.

-RH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 11:23 AM	#1
2077delta Board Regular Join Date: Feb 2002 Posts: 217	I would like to create a pivot table from a query in Access. However when I connect to the query through the wizard, it won't let me run the query. If I try to run the query I just get a beep, no error message. If I try to add a filed from the Access query to MS Query I get an error message that reads "Too few parameters. Expect 1". My Access query is actually a summary query of another query that retreives the detail data I need for the summary. In addition the detail query in Access has one parameter it prompts the user for. Is this type of query unusable for MS Query? Can I build a multi-level query in MS Query like the one I have in Access (although I hate to duplicate the effort)? Is it better to bypass MS Query and use VBA in some way to connect to the tables or Access query and run the query?

Mar 28th, 2002, 01:35 PM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	The parameter in the query is what's causing your problem. You could use VBA to set up your pivot table, and could use an InputBox to ask the user for the parameter value. -RH