>Boss man wants a count to appear on the last page of the report
>
>Due to the vagaries of the data gathering requirements on this report, I cannot use a summing field for the count, I have to run another query and pass the count into the report as a variable. Since the count is in the Page Footer, it is showing up on every page.
>
>I just need it to print on the last page. Any suggestions?
Simple. Add Print when condition for recno() = Total number of records in the table.
If it's not broken, fix it until it is.
My Blog