Jim Hewson
JHewson at karta.com
Wed Oct 13 13:24:42 CDT 2004
Mark, Instead of referencing the footer with your header, use a Domain function. You can use the DSum() function using the underlying query for the total in the header. Jim H. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Wednesday, October 13, 2004 12:59 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Report Footer Causes Extra Page Chris, Thanks for the suggestion to verify that the problem lies with the report footer. I deleted the report footer and the blank page no longer prints. Now that we have confirmed that it is the report footer and I still need the functionality of the report footer "sum"...how can I prevent the report footer from printing? Mark -----Original Message----- From: Mackin, Christopher [mailto:CMackin at quiznos.com] Sent: Wednesday, October 13, 2004 12:14 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report Footer Causes Extra Page Sounds like it may not be the Report Footer, have you tried deleting the Footer and running it to see if you still get the extra page? -Chris Mackin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Wednesday, October 13, 2004 10:10 AM To: [AccessD] Subject: [AccessD] Report Footer Causes Extra Page Group, I have an 8" report set to 4 2" columns. I utilize a report footer to hold an overall sum, which I reference in the report header. Currently, the report prints an extra blank page which I am assuming is the report footer. Current settings for the report footer section are: Visible=No CanShrink=Yes Current settings for the "sum" control are: Visible=No CanShrink=Yes What am I missing? I don't want to print this blank page but can't seem to find a combination of settings to prevent it. Mark -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com