Grand Total Page Breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a simple access report that groups by region and does a page break
after each. However, my grand total page appears on a page by itself. Anyway
to have the Grand total print on the last page of the report?
 
Mark, how did you get the report to create a grand total? Did you use a text
box? If so, move it into the report footer. Otherwise, In the report footer
you can insert a text box and put in code like =sum([fieldname]). IThe grand
total will only show on the last page that way.
 
Bonnie:

I have the grand total in the report footer. It's a combination of count and
sum fields. Everything is calculating okay, it's just that there is a page
break before the grand total. I would like the grand total to print on the
last page of the report without forcing a page break.

Thanks, Mark

Bonnie43 said:
Mark, how did you get the report to create a grand total? Did you use a text
box? If so, move it into the report footer. Otherwise, In the report footer
you can insert a text box and put in code like =sum([fieldname]). IThe grand
total will only show on the last page that way.

Mark said:
I've got a simple access report that groups by region and does a page break
after each. However, my grand total page appears on a page by itself. Anyway
to have the Grand total print on the last page of the report?
Click to expand...
Click to expand...
 
Back
Top