[AccessD] Page numbers in Subreport

[David Emerson]

Hi Listers,

 

I have a report that has three subreports (and nothing else).

 

The subreports take up whole pages and near the bottom of each report is a
field with "=[Page] & " of " & [Pages]" as the control source.  If I run the
subreports on their own they show the correct page numbers for their report.
Depending on one of the fields in the subreport data, each record may fill 1
or 2 pages (always whole pages)

 

When I run the combined report the page numbering shows "0 of 0" (which I
have found is a "feature" of subreports).  I am wanting them to show the
numbers as if the page number fields were on the combined report (eg page x
of {total number of pages from the combined report}.

 

Because the position of the page numbering is not at the very bottom of the
sub reports it cannot go in a page footer of the combined report.

 

Does anyone know how I can get the page numbering of the subreports to
appear correctly?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand