Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft+access+course+london - pivot table report

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course+london - Pivot Table report

microsoft+access+course+london - Pivot Table report

ResolvedVersion Standard

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

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

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?

RE: Pivot Table report

Don't worry, I have run the macro from the query and set it to the Switchboard all sorted thanks

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.