Access 2007
in [Reports]
|
Prev: Report only one page
Next: Access Report Calendar
From: Timothy Langaster on 30 Jul 2006 15:54 How I can use to print the total amount in the last page in a report in Access 2007 as: If (Pages)>1 Then [Totals] print to the last page Else [Totals] print to the first page End If
From: tina on 30 Jul 2006 20:31 well, i don't know how different Access2007 is, but have you tried putting the [Totals] control in the ReportFooter section? the section should print at the end of the report, whether it be one page or 10 pages, or a hundred pages, or... hth "Timothy Langaster" <TimothyLangaster(a)discussions.microsoft.com> wrote in message news:5AA7BD48-4026-4641-8338-6C6A27827FB0(a)microsoft.com... > How I can use to print the total amount in the last page in a report in > Access 2007 as: > If (Pages)>1 Then > [Totals] print to the last page > Else [Totals] print to the first page > End If >
From: tina on 30 Jul 2006 20:31 well, i don't know how different Access2007 is, but have you tried putting the [Totals] control in the ReportFooter section? the section should print at the end of the report, whether it be one page or 10 pages, or a hundred pages, or... hth "Timothy Langaster" <TimothyLangaster(a)discussions.microsoft.com> wrote in message news:5AA7BD48-4026-4641-8338-6C6A27827FB0(a)microsoft.com... > How I can use to print the total amount in the last page in a report in > Access 2007 as: > If (Pages)>1 Then > [Totals] print to the last page > Else [Totals] print to the first page > End If >
From: Timothy Langaster on 31 Jul 2006 00:51 Dear Tina, Thank you for your reply. It’s the same also to Access 2007 but my question remain as I need to put the total of the invoice in the last page and in a specific position. "tina" wrote: > well, i don't know how different Access2007 is, but have you tried putting > the [Totals] control in the ReportFooter section? the section should print > at the end of the report, whether it be one page or 10 pages, or a hundred > pages, or... > > hth > > > "Timothy Langaster" <TimothyLangaster(a)discussions.microsoft.com> wrote in > message news:5AA7BD48-4026-4641-8338-6C6A27827FB0(a)microsoft.com... > > How I can use to print the total amount in the last page in a report in > > Access 2007 as: > > If (Pages)>1 Then > > [Totals] print to the last page > > Else [Totals] print to the first page > > End If > > > > >
From: Timothy Langaster on 31 Jul 2006 00:51
Dear Tina, Thank you for your reply. It’s the same also to Access 2007 but my question remain as I need to put the total of the invoice in the last page and in a specific position. "tina" wrote: > well, i don't know how different Access2007 is, but have you tried putting > the [Totals] control in the ReportFooter section? the section should print > at the end of the report, whether it be one page or 10 pages, or a hundred > pages, or... > > hth > > > "Timothy Langaster" <TimothyLangaster(a)discussions.microsoft.com> wrote in > message news:5AA7BD48-4026-4641-8338-6C6A27827FB0(a)microsoft.com... > > How I can use to print the total amount in the last page in a report in > > Access 2007 as: > > If (Pages)>1 Then > > [Totals] print to the last page > > Else [Totals] print to the first page > > End If > > > > > |