Hi Team,

My Access report is three pages of member names and addresses. I have a "count" footer that displays the number of members correctly but it will not print on the last page of the report even though there is plenty of room. It prints on a new page even though the last report page is only half used.

Can someone tell me how to get the footer to print on the last page of my report? I have tried all the settings for "force new page" in the properties box, but the footer always makes its own new sheet.

Thanks for some advice.
Muchy

Is it in the Report Footer or the Page Footer? - Check
The Report Footer (like the Report header) will print on it's own page.
If the count is relevent to the Detail ie members then it should go in the Page Footer. ;)

Thanks Lightray, but what won't a page footer display on every page? I would like to have the total of members listed shown on the last page of the report. Now the footer prints the total on a new page after the last page of the report.

Sorry, Lightray, I forgot to mention that the count function is in a report footer.

What happens if you put the count function on the Page Footer?

There's an example here
http://www.access-programmers.co.uk/forums/showthread.php?t=90968

Rich,
Thanks for the reference. That should give me something to work with.

Lightray,
I get an error message when I put the function in the page footer. Looks like Rich has a good reference here.
Thank you both.