Page Numbers

[Nikki]

Is there a way to print the page number of the report for that record at the
bottom of the page?

eg: If the report has 3 pages but there are 50 records each the first page
of each record would say 1 of 3, second say 2 of 3 and so on.
At the moment I have a 2 page report but when i print them it says 1 of 220
because it is counting all the pages of every record.

 

[Jeff Boyce]

Nikki

I don't understand "counting all the pages of every record".

If you want to put "Page x of y" at the bottom of each page in an Access
report:

* open the report in design mode
* make sure you have Page Headers/Footers showing
* add a control to the page footer (assuming you want the page number at
the bottom)
* use the following expression - pay attention to the quotes and spaces:
="Page " & [Page] & " of " & [Pages]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

Check http://www.mvps.org/access/reports/rpt0013.htm at "The Access Web"

 

[Nikki]

Can you please clarify what it means when it says "change Me!Salesperson to
the control name of the group you wish to track pages for"

 

[Douglas J. Steele]

Presumably you've got a text box on your report that holds the field that
triggers starting a new page. That's the control you'd use instead of
Me!Salesperson.

 

[Nikki]

Oh ok. No I don't have one. I have a page break that triggers the new page.
Will that work?

 

[Douglas J. Steele]

But why do you skip to a new page? Surely it's not arbitrary, or you
wouldn't care whether your report says 1 of 3, 2 of 3, 3 of 3, 1 of 2, 2 of
2, vs 1 of 5, 2 of 5, 3 of 5, 4 of 5, 5 of 5

 

[Nikki]

Because the report itself has 2 pages. When I print of one record at a time
it does say 1 of 2, 2 of 2. BUT when I print all of the records (256 of
them) at the same time then the first record says 1 or 516, 2 of 512, the
second record says 3 of 512, 4 of 512 and so on.

 

[Douglas J. Steele]

Sorry, I'm not understanding your explanation.

Are you saying each record is supposed to be a pair of pages? Replace
Me!Salesperson with whatever field represents the Primary Key of your table,
then.