>Greetings,
>
>Before I submit the Print command, I have a line of code nCOUNT = RECCOUNT()
>
>Then within the report, I've set up a "field" inside the Page Footer, and in the "expression" typed nCOUNT. Within the "properties" of this field, I clicked "calculations" and select "END OF REPORT"
>
>The results are that it prints the number of records "for that page" at the bottom of the first page, the second page is the number of records for page 1 & 2. Finally the 3 page has the desired number.
>
>What I would like to have it that the number only print at the end of the report.
>
>Thanks everyone,
>Ruben
Put it in summary band
**** Update
If you want this to be printed in Footer then put in the page footer but in Pinet When put:
_pageno == _pagetotal
Keep in mind that _pagetotal cause the report run twice
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.