wrong value for Pages

[srobbins]

Someone posted this question before, but there was no response.

I have a field in the Page Header section with the following control source:
=Page " & [Page] & " of " & [Pages]

The report is 7 pages long, but the field shows "Page 1 of 6", "Page 2 of 6", etc. with the last page showing "Page 7 of 6."

What have I done to cause this?

 

[khawar]

can you upload the report for viewing

 

[Rich]

What are the results if you move it to the footer?

 

[srobbins]

I seem to have solved this problem. There was some code for the GroupHeader0 and GroupHeader1 on print events. When I moved it to the respective on format events, the page numbering corrected itself. Can't say I totally understand, but I'm happy that it's working!