Column Report Total End of 2nd Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bingo - 24 Apr 2008 02:05 GMT

I have a column report set to two columns that sums PBO by state. I want to
have a total sum at the end of the report (after the last state listed). A
report total will be on a second page since the first column is the page's
length but the second column is only half a page.

I have a report header, detail, report footer. A query provides the summed
PBO by state. I want to have the total shown in the simple example below:

MD 5 NC 1
TX 4 WV 2
CA 3 TOTAL 17
SC 2

Thanks

Reply to this Message

Marshall Barton - 24 Apr 2008 05:52 GMT

>I have a column report set to two columns that sums PBO by state. I want to
>have a total sum at the end of the report (after the last state listed). A
[quoted text clipped - 8 lines]
>CA 3 TOTAL 17
>SC 2

Create a group with footer (View menu - Sorting and
Grouping) using a constant expression such as =1. Then add
your total text box with expression =Sum(PBO) to the group
footer.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Bingo - 24 Apr 2008 13:56 GMT

Worked great - thanks

> >I have a column report set to two columns that sums PBO by state. I want to
> >have a total sum at the end of the report (after the last state listed). A
[quoted text clipped - 13 lines]
> your total text box with expression =Sum(PBO) to the group
> footer.

Reply to this Message