Report footer printing on separate page

Help! I have tried everything I can think of!

I have a report with several subtotaled sections, and a subreport. A "grand
total" is supposed to display after the last entry/subtotal of the main
report. For some reason, that Grand Total (which is in the report footer)
prints on the next page of the report, not directly under the report. It will
print on the top of the next page, with the subreport immediately following
it.

How can I get the "grand total" to print right under the main report where
it should? I have looked at Group Together, Force Page Break, and just about
any other thing I can think of. Please help!

Thanks!

Temporarily set the Force New Page property to None for all sections of the
report, delete any Page Break Control anywhere in the report, and comment
out any code in the report's module.

If that fixes the problem, then start adding back the properties you need.
You may be able to solve the problem by setting Force New Page to Yes for a
group header instead of for the group footer (assuming there's no report
header to worry about.)

If it does not fix the problem, double-check the height of the Report Footer
section. Keep it minimal.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GoBrowns!" wrote in message
...
Help! I have tried everything I can think of!

I have a report with several subtotaled sections, and a subreport. A
"grand
total" is supposed to display after the last entry/subtotal of the main
report. For some reason, that Grand Total (which is in the report footer)
prints on the next page of the report, not directly under the report. It
will
print on the top of the next page, with the subreport immediately
following
it.

How can I get the "grand total" to print right under the main report where
it should? I have looked at Group Together, Force Page Break, and just
about
any other thing I can think of. Please help!