expression "Page " & [Page] displays always 0

A

Ayala

Hi, I made a subreport to be the footer of a main report.
In one section of the subreprot I'm using the expressions:
="Page: " & [Page]
and
="Pages: " & [Pages]

Openning the subreport (not the main report with the
subreport) the page numbers are displayed ok. But in the
main report when placing the subreport in the footer
always displays 0

How can I make them to display the page numbers?
 
W

Wayne Morgan

The page numbers will come from the Parent report.

Try
="Page: " & [Parent].[Page]
And
="Pages: " & [Parent].[Pages]
 
R

Rick Brandt

Ayala said:
Hi, I made a subreport to be the footer of a main report.
In one section of the subreprot I'm using the expressions:
="Page: " & [Page]
and
="Pages: " & [Pages]

Openning the subreport (not the main report with the
subreport) the page numbers are displayed ok. But in the
main report when placing the subreport in the footer
always displays 0

How can I make them to display the page numbers?

Subreports "don't know nuttin bout no pages".

All page activity is the domain of the parent report. Just put these in
the parent report's page footer.
 
G

Guest

Great! thank you
-----Original Message-----
The page numbers will come from the Parent report.

Try
="Page: " & [Parent].[Page]
And
="Pages: " & [Parent].[Pages]

--
Wayne Morgan
MS Access MVP


Hi, I made a subreport to be the footer of a main report.
In one section of the subreprot I'm using the expressions:
="Page: " & [Page]
and
="Pages: " & [Pages]

Openning the subreport (not the main report with the
subreport) the page numbers are displayed ok. But in the
main report when placing the subreport in the footer
always displays 0

How can I make them to display the page numbers?


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top