[AccessD] Access 2010 Report footer at Page Bottom

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
>