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?