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

access advance

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007 Advance

Access 2007 Advance

ResolvedVersion 2007

Paul has attended:
Access Intermediate course

Access 2007 Advance

When doing a report, how do you force a grouped section onto a new page?

RE: Access 2007 Advance

Dear Paul

Thank you for attending the Access Intermediate course. I hope you enjoyed the course and benefited from it.

In order to separate the grouped sections to appear on a new page you go to the Design view of the report.

Right-click on the details section and choose Properties.

Click on the section

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.