[AccessD] Report Footer on Last Page of Group

I have a report that creates invoices.  When the report is run it 
includes invoices for several businesses.  At the bottom of each 
business invoice is about 1/3 of a page of "footer" text.  Most of 
the invoices fit onto one page.  My problem is when the invoices 
spill over onto more than 1 page.

If I put the "footer" text into the footer section for the business 
then they appear at the end of the businesses invoice but may not be 
at the bottom of the last page.

If I put the "footer" text into the page footer section then it 
appears at the bottom of each page but also on the pages where there 
might be more than one page for a business.  Because the "footer" 
text takes up so much space I do not just want to hide the fields if 
it is not on the last page for a business because this will leave a 
large amount of blank space on the pages before the last one.

How can I use the space that would be taken up by the footer if I put 
it into the page footer section, or alternatively, how can I put it 
at the bottom of the last page of each invoice if I put it in the 
Business footer section?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand