Can i create an Access report from a Pivot Table view?

I have some tables from which i have created Pivot Tables to view the data better. can i create an Access report from a Pivot Table view? I've encountered some problems while trying to do this because it will create the report out of the table itself not out of its Pivot Table view.

Is this somehow possible?

I'm not sure what you are asking. Are you asking to print a pivot table as a report in Access? If so, why not export the pivot table to Excel and print it there? Or run the query and export it to Excel -- run your pivot and print or distribute it? Data manipulation is often easier in Excel than in Access.

Alan

I know but I have a client that wants the Pivot Table to be in Access. So I have a table that I open and then when i go to this table's Pivot Table view i have a Pivot Table set up there.

I also found another way of making a Pivot Table in Access by going to Forms/More Forms/Pivot Table and I was able to do there but I don't seem to be able to create an Access report out of this form either. When i try exporting this form to excel, I will not export the calculated fields I have on the Pivot Table.

Any ideas?

Found this when I did a google search. Most of the searches came back telling how to create a pivot table, which is not what you are looking for. If this is not your answer, then I would start doing some google searches. I am sure it is out there, but not often used and will probably require some VBA.

http://bytes.com/topic/access/answers/504462-pivot-table-report

Good luck

Alan