grouping shows total per page, not for whole group

[jnikle]

I have a report that has three grouping levels: month, week, and days.
In each of the footers for these groups I calculate a sum.

If the number of records for a given week won't fit on one page, then I
get a total for whatever of that week is on the first page, and then I
get another total for whatever's left on the second page.

I've played with the groups' properties and looked in help, but I can't
find a solution to my problem. I need one total for the week no matter
how many pages that week covers.

Thanks in advance for any suggestions.

-Josh Nikle

[rquintal]

[e-mail] m May 14, 3:59 pm show options

Newsgroups: comp.databases. ms-access
From: [e-mail] m - Find messages by this author
Date: 14 May 2005 12:59:14 -0700
Local: Sat,May 14 2005 3:59 pm
Subject: grouping shows total per page, not for whole group
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
Josh said

I have a report that has three grouping levels: month, week, and days. In each of the footers for these groups I calculate a sum. If the number of records for a given week won't fit on one page, then I get a total for whatever of that week is on the first page, and then I get another total for whatever's left on the second page.

You have "Repeat Header" true for the week. This is what resets the
running suml.

Solution: Create a new Group By row with the same group on clause as
for the week, and set the sum on the outer Group, and the repeat Header
on the inner Group.

Bob