Acces 2003 report

I ahve a database that generates a report with a variable number of pages.

Sometimes the last page (which is configured to be in the report footer of
the whole report) has not data to be printed. But usually there is
information to be printed.

I use the inbuilt "Page x of y" to print the page number on the report
within the page footer.

My question is : If there is no information associatecd with this last
section of the report to be printed, how can I get the report to say page x
of (y-1) throughout the report, at the moment the headings (labels) for teh
last section are permanent fixtures as is the page numbers.

I think what i want is the report footer only to appear (and if it does it
is to be always a separate page, ioe the last page of the report) if there is
dat to be printed, else the previous page (ie the last set of main report
data) is teh last page and the page xof y reflect this........help
--
Regards


Patrick Stubbin