Page Numbering

[vanny]

I have a problem with the Page Footer consisting of the Page Numbering :

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

It is counting all the pages for example if in all there are 3 pages on each page it shows:

Page 1 of 3
Page 2 of 3
Page 3 of 3

However I wish that the last page is not added, that is if in all there are 3 pages, it shows:

Page 1 of 2
Page 2 of 2

Is there a way that I can do it?

Thanks in advance for any help.

 

[Rickster57]

pages

Well, you could use [Pages]-1.
Then in the On Print event of the Page Footer you could hide the ="Page " & [Page] & " of " & [Pages] if [Page]=[Pages]

 

[vanny]

Thanks for the help that worked successfully.

However I still have another problem with another report. This report is divided into various Footers and it has a Footer named ProformaFooter, and then it has the Page Footer which has the same page coding :

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

This time what i would like to do is to simply include all pages EXCEPT those in the ProformaFooter. So if the ProformaFooter has 2 pages and the whole report consists of 4 pages it still shows:
Page 1 of 2
Page 2 of 2
Thus not counting the other 2 pages on the ProformaFooter.

Is there a way which I can go about this problem?

Thanks for any help