Dear All,

How to count the number of records per page per report? (I am using Access
2000).

Thank you very much.



Arthur Cheung

Arthur,

Do you want to know the answer before you print the report, or do you
want to put a record count at the bottom (or top) of each page?
If the former, you are on your own: if the latter, try declaring a
variable intRecs as Integer in the report code module, them zero it
whenever the page header is printed, add one to it on each 'OnPrint'
event for the section containing the record detail you are tracking and
subtract one from it in each 'OnRetreat' event fore the same section. By
the end of the page, intRecs will contain the number of records
successfully rendered on the page and you can print this in a control in
the page footer.

Just my $0.02

Doug


Arthur Cheung wrote: