about page number in report

[deadfish]

Hi,

I would like to show the page number in each page of the report. The report has a group, customer. I would like to show the page number in the format of =Page " & [Page] & " of " & [Pages]. I can reset the page number in group but I don't know how to retrieve the total number of pages for each customer.

I mean to show:
customer 1
page 1 of 3, page 2 of 3....
customer 2
page 1 of 2, page 2 of 2

...

How to archieve this? Thanks!

 

[GingerR]

Hi. Try this:

http://support.microsoft.com/?kbid=209215

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[deadfish]

Thanks!
I have try that to reset the page number. But I don't know how to get the total number of page for each customer...

 

[GingerR]

Check out this thread, and use the information in THWatson's third post. I just tried it, and it worked fine. One thing I had to tweak was this:

My "PageHeader" is called "PageHeader" and THWatson used "PageHeaderSection" (first line of code), so you may have to tweak that as well.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[GingerR]

Oops, forgot the thread number:

thread703-1086096

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html