Robin,
I my test 2 column report I didn't get an extra page. It certainly should be caused by a count() in an existing header. I would check through all the format type properties of all sections.
It isn't clear whether your columns go across then down or down then across. Your subject line suggests "two column" but you also stated "fourth column".
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 2 Apr 2015 08:27:50 +1100
Subject: RE: [MS_AccessPros] Totals in footer of two column report. Alternate choise.
Duane,
I have tried with the count displayed in the existing header which is an acceptable result. The only problem is that it leaves a blank page three.
Cheers,
Robin
At 2/04/2015 12:56 AM, you wrote:
I my test 2 column report I didn't get an extra page. It certainly should be caused by a count() in an existing header. I would check through all the format type properties of all sections.
It isn't clear whether your columns go across then down or down then across. Your subject line suggests "two column" but you also stated "fourth column".
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 2 Apr 2015 08:27:50 +1100
Subject: RE: [MS_AccessPros] Totals in footer of two column report. Alternate choise.
Duane,
I have tried with the count displayed in the existing header which is an acceptable result. The only problem is that it leaves a blank page three.
Cheers,
Robin
At 2/04/2015 12:56 AM, you wrote:
Robin,
Try add a new top level sorting and grouping on an express like =1. Display the footer for this new section and move your count there.
Duane Hookom, MVP
MS Access
> Date: Tue, 31 Mar 2015 16:23:12 +1100
> Subject: [MS_AccessPros] Totals in footer of two column report.
>
> I have a two column report where the fourth column finishes before
> the end of the page.
>
> I have added a field in the footer to count the entries but it is
> printed on page three.
>
> How do I get the count at the end of page 2?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar