Report footer at bottom of page

[KenN]

I have a report that has a page footer that needs to appear on every page except the last one. On the last page I want the report footer to show and not the page footer. This works fine, except the report footer appears at the end of the last line of data instead of the bottom of the page. Is there a way to force the report footer to the bottom? Even if the answer is no, please respond so that I can quit banging my head against the wall. My head and the wall need a break.

 

[Crawforda]

I am in no way fluent with access, but I have had a similar problem and got around it by doing the following.
Right-click the Report Header and Force New Page - After Section
then
Right-click the next footer just above the report footer (StaffName footer in my case) and Force New Page - After section

I'm not sure if this is what you're tried before, and you may need to move the contents of the report header around to get the best results. But I hope this is of some help and points you in a new direction.