Jim Dettman
jimdettman at earthlink.net
Mon Jun 28 08:24:18 CDT 2004
Steve, Place your total in the page footer. In the page footers OnFormat event do: If Me.Page = Me.Pages Then ' Make the totals visible Else ' Hide them End If Note that you must place a control on the report somewhere hidden or visible that references the .Pages property for this to work. Jim Dettman (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Conklin (Developer at UltraDNT) Sent: Friday, June 25, 2004 4:11 PM To: 'Access Developers discussion and problem solving' 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