Page Count On Report

[Paul M.]

Hello,
at the bottom of each page (page footer) I have a field (text)
which simply states:
Page n of nn

Just the current page of the total number of pages in the report.

The "nn" part I get using the standard Access [Pages] function but the it
gives an incorrect value, any one got any ideas?

Thanks
Paul Mitchell

 

[Dave Brydon]

Paste the following into the control source:

="Page " & [Page] & " of " & [Pages]

HTHs
Dave

 

[Brendan Reynolds]

Dave's suggestion elsewhere in this thread should solve your problem, Paul.
It's worth bearing in mind, though, that if the report includes a large
number of pages, this can be a very significant performance hit. It forces
Access to format the report twice - once to calculate the number of pages, a
second time to go back and fill in the page numbers.

Depending on the circumstances, the information may or may not be important
enough to justify the performance hit.

 

[Paul M.]

Hi Dave,
sorry I should have been clearer but thats the way its done
at the moment.
Thanks
Paul

Paste the following into the control source:

="Page " & [Page] & " of " & [Pages]

HTHs
Dave

Hello,
at the bottom of each page (page footer) I have a field (text)
which simply states:
Page n of nn

Just the current page of the total number of pages in the report.

The "nn" part I get using the standard Access [Pages] function but the it
gives an incorrect value, any one got any ideas?

Thanks
Paul Mitchell