Creating a report total with 2 columns (2002)

Topic

New Reply

I created a report where I want the total money collected showing in the report footer. This works great until I make 2 columns. When I make 2 columns, I would like the total to show at the bottom of the last record in the second column. Instead it creates a new page and displays it at the top of it. What’s the trick here? How can I get the total to show where the report ends no matter which column it ends in?

Reply | Quote

Replies

Follow the thread starting at this post: post 226,926

It will give you what you are looking for. Use Han’s revised version of my original. As usual, more elegant than the rest of us produce.

Reply | Quote

My computer wouldn’t trust the source of Hans’ database. From what I read from the other posting, though, the problem was the column heading shifting to the next column when there was nothing there. My problem is quite different. I want a total of a value in the columns to appear in the second column. If I have 2 columns, this doesn’t happen, at least, when I do it.

Reply | Quote

The report footer will always span the entire page width, regardless of the number of columns. You can create a ‘fake’ report footer at the end of the last column as follows:
– Open the report in design view.
– Activate the Sorting and Grouping window.
– Add a dummy grouping level with Field/Expression =1
– Set the Group Footer of this grouping level to Yes.
– If you have other sorting/grouping levels, drag the new grouping level to the top of the list.
– Move the control(s) from the report footer to the new group footer, taking care you don’t use more space than the width of a column.

Reply | Quote

The reason I sent you to that thread was because the total does float. It is a statement form I use in the church database for quarterly givings statements to parishioners. Regardless, Hans’ posting explains in words (probably more quickly and easily than examining the database!) what is needed.

Reply | Quote

Works like a charm. Thank you so much.

Reply | Quote