[AccessD] Report Footer as Page Footer, Last Page Only

WAG: If you can determine what the last record of the report is in the Open
event of the report (use a recordset bound to the same query as the report
but with the MAX function to return only the last record), you could put the
grand total in the page footer but make it invisible until the last record
is detected in the format event of the detail section at which point you
make the controls showing the total visible.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Steve Conklin (Developer at UltraDNT)" <Developer at ultradnt.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, June 25, 2004 1:10 PM
Subject: [AccessD] Report Footer as Page Footer, Last Page Only


> I need to have my grand total show only the last page of a report (like
> a report footer), but always on the bottom (like a page footer) instead
> of right after the last detail line.
>
> How whould I do this? And on which one of these? (Report Footer all the
> way on the bottom or Page Footer that only shows on the last page?)
>
>
> TIA & TGIF
> Steve
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>