Totalling Sections

[Microsoft]

Access 2007

I have 3 levels of grouping
PageNo (userdefined from 3rd party docs) - total in footer
SectionHdr - total in footer
SubSectionHdr - total in footer

The footer for PageNo has a break after the section so that the user defined
page no starts on a new page for each.

Problem:
When the SectionHdr has items on more than 1 page (i.e Pages 1 and 2 as
defined by the user) it gives the incorrect total. i.e it only adds up the
items that relate to the new PageNo.

How can I get around this?
Is there a better way to do this?

Thanks

Alison