Page of Pages

fenhow

Registered User.
Local time
Today, 07:35
Joined
Jul 21, 2004
Messages
599
Hi,

I have a report that goes like this
Report Header
Page Header
Data1 Header
Data2 Header
Detail
Data1 Footer
Page Footer
Report Footer

In the Page Footer I have ="Page " & [Page] & " of " & [Pages]


When I run the report it starts a new page when it should but the [Pages] is showing the total number of pages in the entire report not in the group as indicated by Data1 Header.

Any suggestions?

Thanks.

Fen How
 
Thanks, ok I want it to show Page 1 of 3 for an example and when a new group starts it begins over again.

Is that possible?

Thanks
 
Well, you said you put ="Page " & [Page] & " of " & [Pages]
in the Page Footer. Have you tried it in the Data1 Footer?
 
Yes, i have tried it all over the place and it wants to count all of the pages in the entire query. It starts at each new page but says 1 of 6775 etc..,

Thanks.
 
You have to use code as in this example
 

Attachments

Users who are viewing this thread

Back
Top Bottom