ACCESS FEED: RE: [MS_AccessPros] Totals in footer of two column report. Alternate choise.

Rabu, 01 April 2015

RE: [MS_AccessPros] Totals in footer of two column report. Alternate choise.

Thanks for your patience Duane,

The columns go down the page and the reference to column four translates as column two on page two. It is a very small report!.

I now have the resident count in the header and only two pages.

Success.

Many thanks,

Robin Chapple

At 2/04/2015 09:01 AM, you wrote:

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:

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