microsoft+access+course+london - pivot table report

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

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

resolvedResolved · Low Priority · Version 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


 

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips


Server loaded in 0.09 secs.