I have an Access 2003 report. In the detail section, I accumulate certain totals to display in the footer of the first level break. What I find is that if the detail lines cross a page boundary the first detail line of the second page is added twice. Thus the totals for the first level totals are too high by this amount. Is this a known bug and is there a good workaround or fix?

Right click on that detail section and set force new page to before section

That's a good workaround but I'd rather solve the problem. That solution would result if too many extra pages.

Hi,

I got the answer in another forum.

http://answers.microsoft.com/en-us/office/...91-08f9fc6e3c00