Hello,



I have a report that I am working on and I have it grouped by ZONE, FUNDING SOURCE and FYQTR. I have a page break at the end of each ZONE and also FUNDING SOURCE because we want to break those up by page, however, after the last FUNDING SOURCE for each ZONE I get a page break. What I would like to be able to do is have a page break for each new FUNDING SOURCE but not after the last FUNDING SOURCE FOOTER for that particular zone.

What we see now is after the final FUNDING SOURCE there is a page break, then a new page with the FOOTER for that ZONE, then a new page for the next ZONE. I would like the have the FOOTER for ZONE right after the final FUNDING SOURCE FOOTER.

What I have now is FORCE NEW PAGE set to After Section for FUNDING SOURCE.

I'm using access 2007.