Page Breaks (1 Viewer)

[tomc]

This is probably very simple but I am trying to do reports that have a page break after each department. That's easy. The problem I'm having is that I'm doing a record count for each department and then a total for the entire report. Because I have the page break after the department it always puts the report total on a new page. I'd like it to be on the same page as the total for the last department.

I want to keep the department no. and name in the page header.

Thanks

 

[Richie]

Group by dept and put the calculations in the group footer

 

[tomc]

Thanks, Richie, I've done that and it works fine for the dept. totals but when I run the report for multiple departments it puts the full report total, which I have in the report footer, on a new page.

Tom

 

[Richie]

Put in the report header?