I have a report, which lists the staff in several offices throughout the UK (the user can select which offices to include). Users want each office to be on a seperate page, so I have put a page break in the footer of the office group. I have also put a label in the footer, which displays the number of people in each office.

Users also want the total number of people in each report. I have placed a label in the report footer, which counts the number of people, but because of the page break in the office group footer, this displays on a seperate page.

Is there any way to have the total number of people to display on the same page as the last office, without having it display on every page?

TIA

Move the page break from the footer to the header. You don't need any controls in the header, you only need to have it defined.

Sorry Pat, I don't quite understand what you mean.

If I move the page break to the header, then the data in the Details section will be displayed on the page after the name of the office.

You said you have the page break in the office group footer. Move it to the office group header.