Pivot Table from Access

[2077delta]

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]

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