Group Footer on same page with last subgroup

[spitzmuller]

Hi there

I have a report that groups stuff on 3 levels. Now the outermost group Footer sometimes gets printed on the last page, while the last subgroup is printed on page before that one (which looks a little stupid because this footer holds name and signature of an official document and is printed with nothing else on the last page)

I would like to have Acces - whenever this situation occurs - to move the last subgroup to the last page as well.

Is that possible

Thanks in advance Simon

 

[THWatson]

spitzmuller
Microsoft has an article that discusses the way to make a conditional page break. See if it helps.

Go to the following link...

http://office.microsoft.com/en-us/assistance/HP051873361033.aspx

Tom

 

[spitzmuller]

Good hint. Thanks Tom

Still don't know how to write such a condition since Access renders the reports.

Simon

 

[dorianr]

I have the same issue - multiple group summaries that need to appear together (there are sometimes 4 group summaries). Ideally, if they won't fit on the same page, I would like to have at least 3 detail rows also move to the next page. This way the next page will have 3 detail rows, and 4 group summaries. Any ideas?