Keep report total on last page if room

N

news.microsoft.com

I have a report like so:
Page Header
Dept Header
WC Header
Detail Section
Dept Footer
Page Footer
Report Footer

So that I can have a new page for each Dept I have inserted a Page Break in
the Dept Footer - all works fine HOWEVER,
I have a total in the Report Footer that appears on a page by itself.

Q. Is there a way of telling access to only insert the page break when the
next page isn't the report footer so that the total in the the report footer
will print on the same page as the last dept (if there is room of course)

Thanks
EG

Page 1
This is the header
Dept 1
WC1
19/4.04 widget 23
20/4.04 nut 20
Dept Footer 43
----Page Break ----
Page 2
This is the header
Dept 2
WC1
20/04.04 15
Dept Footer 15
Report Footer 58 (This at the moment is being printed on Page 3 all
by itself)
 
F

Fons Ponsioen

If you take out the pagebreak in the footer and instead
set the force new page to before in the department header,
I think it all will work jusat fine.
Fons
 
F

Fons Ponsioen

In the department header, did you set the property "force
new page" to before or did you insert a page break ?
Fons
 
N

Newbie

I set the force new page . . .
Fons Ponsioen said:
In the department header, did you set the property "force
new page" to before or did you insert a page break ?
Fons
Click to expand...
 
F

Fons Ponsioen

I suspect that there is something in the report or page
header ahead of the group header that is causing this.
I have a variety of databases and numerous reports and
when I have a group header starting at a new page I always
use force new page before section, this has never caused a
blank page feed prior to the actual report page.
If you wish I'll gladly look at it if you care to email me
the mdb with a little sample data.
Fons
my email is in the header.
 
Top