>>>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.
>
>Not that simple if you have some active ORDER ;-)
Right. We may also try to use report variable to count number of records and then compare it with the recno(), not sure if this would need to be adujsted by +/-1.
Oops, this would not work, e.g. we can not use recno() here.
If it's not broken, fix it until it is.
My Blog