Can you pull a pivot table from Pivot Table View into a report?

G

Guest

I have designed a pivot table from a query in pivot table view and want to
have it show up on a report with all of the information summarized in the
pivot. Is there a way to do this?
thanks
 
V

Vincent Johns

Yes. Your pivot table is a Query, and you can base another Query, or a
Report, on it just as if it were a Table or a Select Query. Just
specify your Crosstab Query as the data source of your Report, or run
the Report Wizard and base it on your Crosstab Query.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
G

Guest

No, my query is not a Crosstab Query. It is a select query with a Pivot Table
built in Pivot Table view.
 

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

Pivot Table rounding 3
Transform/PIVOT Query 4
Pivot Table View Query as Report? 2
Access #Error & Excel Pivot 0
Export Pivot Table to Excel 1
Excel VBA For excel 0
Open directely to Pivot Table 2
Pivot Table view of Union Query 1

Top