More Subtotals in a Report

  • Thread starter Thread starter John O'Boyle
  • Start date Start date
J

John O'Boyle

I'm apparently not very good at this Access stuff, although I thought I
knew what I was doing. I'm trying to create a simple report with one
subtotal per group, and (possibly) a grand total at the end of the
report. I have five fields in the table; date, payee, amount, memo and
acct. The data is ordered on "acct + date" and is grouped on "acct".
The report has an "acct" header and a "acct" footer in addition to the
report header and footers. I have a text-box in the "acct" footer,
which is "Control-sourced to "amount". I"m not sure if any of this is
correct.

When I print the report, my subtotal shows just the FIRST amount from
each group, added to to the total. This is with "Running Sum" set to
"Over Group". When it's set to "No", the subtotal just shows the FIRST
amount in each group. Setting it to "Over All" has the same effect as
"Over Group".

I'm sure there's a better way to explain this, but has anyone a clue as
to where I'm going wrong?

Thanks for any (and all) help.

JLOB
 
John said:
I'm apparently not very good at this Access stuff, although I thought I
knew what I was doing. I'm trying to create a simple report with one
subtotal per group, and (possibly) a grand total at the end of the
report. I have five fields in the table; date, payee, amount, memo and
acct. The data is ordered on "acct + date" and is grouped on "acct".
The report has an "acct" header and a "acct" footer in addition to the
report header and footers. I have a text-box in the "acct" footer,
which is "Control-sourced to "amount". I"m not sure if any of this is
correct.

When I print the report, my subtotal shows just the FIRST amount from
each group, added to to the total. This is with "Running Sum" set to
"Over Group". When it's set to "No", the subtotal just shows the FIRST
amount in each group. Setting it to "Over All" has the same effect as
"Over Group".
Click to expand...


SOunds like you just want the sum of each Amount in both the
group footer and in the report footer. If so, you do not
need to use RunningSum.

Use the expression =Sum(Amount) in both the group footer
and in the report footer text boxes.
 
Thanks Marshall. Just what I needed. I wasn't using the "=Sum(Amount)"
at all. That did the trick.

JLOB
 
Marshall Barton said:
SOunds like you just want the sum of each Amount in both the
group footer and in the report footer. If so, you do not
need to use RunningSum.

Use the expression =Sum(Amount) in both the group footer
and in the report footer text boxes.
Click to expand...

My problem is similar to this. I have 5 fields in the report - Institution,
Advisor, Project, DocID, and Time. The first 4 fields are text, and Time is
a number. The report is grouped on each of the text fields, and Time is
summed for each DocID as =Sum([Time]) in the DocID footer. Institution may
contain several Advisors, which may contain several Projects, which may
contain multiple DocIDs.

Most of the lines in the report are fine, but a few show two values for Time
for the same value of DocID. The total of the two "subtotals" is the correct
value. I'm not certain, but it appears that grouping is also occurring based
on when the data was entered. Several records entered at time A are grouped,
and others entered at time B are grouped separately, even though they're all
part of the same DocID group.

I've changed the Running Sum value and moved fields around, but the results
are the same. Any ideas? Thanks.
 
Back
Top