>>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 ;-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.