using access for pivot table source

  • Thread starter Thread starter bennettkd
  • Start date Start date
B

bennettkd

I would like to use an access query as the source for my pivot table.
want to have a parameter (in the access query) that can be changed b
the user running the pivot table at run time of the pivot table. th
parameter would limit the amount of data returned, ie, dollars ove
$100,000 or dollars over $1,000,000.

When I try to run the pivot table, i get an error back too fe
parameters. expected 1.

any thoughts!
Thank
 
You can't create a pivot table from a parameter query. You could
programmatically create the query definition as part of the pivot table
code, with the user input included in the definition.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access query not showing as sources for pivot table 2
Access #Error & Excel Pivot 0
Pivot Table won't Get 'r done 1
Column limit for Pivot Table data source 1
Cannot Open Pivot Table Source File 0
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot table change data source 1
Refreshing Pivot Table on a protected spreadsheet tab 1

Back
Top