Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course+london - Pivot Table report
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft+access+course+london - Pivot Table report
Resolved · Low Priority · Version Standard
Reply Wed 29 Nov 2006, 15:35Delegate Jane said...
Jane has attended:
No courses
Pivot Table report
I have created a query from which I then viewed it in Pivot Table view and saved it.
How can I set this pivot table as a report to be viewed from the switchboard?
many thanks
Jane
For upcoming training course dates see: Pricing & availability
RE: Pivot Table report
Hi Jane,
The Pivot table once saved as a report can be run from a macro.
You therefore need to create a macro that opens the pivot report. I suggest using the OpenReport Action in the macro. This then allows you to assign the macro to the Switchboard
Regards
Reply Fri 1 Dec 2006, 12:27Delegate Jane said...
RE: Pivot Table report
thanks, but how do I save it as a pivot report. When I am in pivot table view and I go save as report it does not come up in the correct format?
Reply Fri 1 Dec 2006, 12:29Delegate Jane said...
RE: Pivot Table report
Don't worry, I have run the macro from the query and set it to the Switchboard all sorted thanks
|