Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a report total with 2 columns (2002)

    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?

  2. #2
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a report total with 2 columns (2002)

    Follow the thread starting at this post: <post#=226,926>post 226,926</post#>

    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. <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a report total with 2 columns (2002)

    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.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating a report total with 2 columns (2002)

    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.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a report total with 2 columns (2002)

    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.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a report total with 2 columns (2002)

    Works like a charm. Thank you so much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •