Bill Benson
bensonforums at gmail.com
Fri Dec 5 11:44:29 CST 2014
Hi Charlotte, I misinterpreted the requirement, thank you. Bill On Dec 5, 2014 11:34 AM, "Charlotte Foust" <charlotte.foust at gmail.com> wrote: > Not sure what you want to achieve with that. The report footer always > prints on the last page. The report formats itself before the print occurs > but the page numbering can change depending on the volume of data in the > report. > > Charlotte > > On Fri, Dec 5, 2014 at 6:25 AM, Bill Benson <bensonforums at gmail.com> > wrote: > > > Question: This is probably a catch 22 / non-starter but... is there a > way > > Access can "know" the number of pages in a report without that footer, by > > running a version without the footer in "the background" (as if there > were > > such a thing - am making this up as I go along)... then, re-run the > report > > with a provision that the footer shall not print unless the current page > is > > that page count that was achieved from the previous run? > > > > Feel free to tell me I am off the wall and out of air. > > > > On Thu, Dec 4, 2014 at 1:30 PM, Charlotte Foust < > charlotte.foust at gmail.com > > > > > wrote: > > > > > I've used the dummy group technique many times for both headers and > > footers > > > and it works quite well. > > > > > > Charlotte > > > > > > On Mon, Dec 1, 2014 at 9:13 AM, David Emerson <newsgrps at dalyn.co.nz> > > > wrote: > > > > > > > Thanks Jim, I think that is the way I ned to go. > > > > > > > > Regards > > > > > > > > David > > > > > > > > -----Original Message----- > > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim > Dettman > > > > Sent: Tuesday, 2 December 2014 1:05 a.m. > > > > To: 'Access Developers discussion and problem solving' > > > > Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom > > > > > > > > David, > > > > > > > > Couple methods here: > > > > > > > > http://support.microsoft.com/kb/208979 > > > > > > > > Keep in mind that you can create a dummy group using the expressions > > =1 > > > to > > > > give you a extra header/footer. > > > > > > > > Jim. > > > > > > > > -----Original Message----- > > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David > > Emerson > > > > Sent: Sunday, November 30, 2014 05:40 PM > > > > To: AccessD > > > > Subject: [AccessD] Access 2010 Report footer at Page Bottom > > > > > > > > Hi Listers, > > > > > > > > Does anyone have some simple code that puts the report footer at the > > > bottom > > > > of the last page. I don't want to use the page footer section, just > > the > > > > report footer section. > > > > > > > > Regards > > > > > > > > David Emerson > > > > Dalyn Software Ltd > > > > Wellington, New Zealand > > > > > > > > -- > > > > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >