I want to count and display the number of pages that a section is printed on, eg page 1 of section is page 1 of 2 and page 2 of section is page 2 of 2. My sections can print over 25-30 pages sometimes, as these are faxes I need to give the recipient an indication of how many pages he/she can expect. The section in question is a list of clients relating to the recipient and other information, they are kept together and I force a new page for this header, I've tried "Reset page numbers for each group in a report", but I end up with page 1 on each page of the section. Any help greatly appreciated. I think I'll end up refering to Onformat and FormatCount as this relates to how many pages a section is printed on, but I have not figured out how to use these yet

Use the Access help topic 'Reset page numbers for each group in a report', but put your code/macro behind only the specified grouping. That might do it for you.

HTH,
David R

Thanks very much for the tip, I assume that you mean I should use the macro settings they suggest and then set the properties in the section header or footer to refer to the macro and reset the page number on every new occurance, unfortantly the following pages of the section also have pages number 1 on them as this method does not include any logic to account for sections printed on morew than one page. So, I am still stuck.

I think a macro/code reading the value in Onformat or FormatCount and then replicating the value as a page number is the only way to go, but I have little/no idea how to proceed

PLEASE HELP IF YOU CAN.

Best regards


If you or anyone else can suggest an alternative I'd really appreciate it.

I think the

Look at the 'employee sales by country' report in the sample NorthWinds database.

David R's suggestion seems to work like a charm there, including multi-page detail sections.