Prev: Ole Object visible if...
Next: Multi-Column Report
From: Chiz on 11 Mar 2010 15:54
In Access 2007, I have a report with 2 columns of data with sums created in a
footer. At the bottom of the one-page report, I would like the Grand Total. I
can calculate the Grand Total in the Report Footer, but it jumps to a second
page even when I have plenty of room on the first page. I do not have this
problem when page setup has data reading across the 2 columns, but I would
like the data to read vertically and not horizontally. Thank you.
From: Marshall Barton on 11 Mar 2010 18:39
Chiz wrote:

>In Access 2007, I have a report with 2 columns of data with sums created in a
>footer. At the bottom of the one-page report, I would like the Grand Total. I
>can calculate the Grand Total in the Report Footer, but it jumps to a second
>page even when I have plenty of room on the first page. I do not have this
>problem when page setup has data reading across the 2 columns, but I would
>like the data to read vertically and not horizontally.

You can get the grand totals to appear in a column (after
the group footer) by inserting a top level group using a
constant expression such as =1. Then a text box in this
group footer can use expressions like =Sum(amount) just
link in your existing group footer.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Ole Object visible if...
Next: Multi-Column Report