Group Sum

[rob p]

I had previously posted about this and got solution for total sum. I need a
little different sum and can't seem to figure it out.

Main report has records AAA, BBB, CCC.
AAA has one subreport record with amount of 1,000. Same with BBB. CCC has
two records with amounts of 1,000. Total of amount is 4,000.)

My report has one record per page with an amount like this:
AAA 1,000
next page
BBB 1,000
next page
How do I get
CCC 2,000 instead of two amounts of 1,000 showing up. I tried
=SUM([Amount]) but that give me sum of all (4,000) not just for the CCC
record. By the way, this could be any record with multiple amount, not just
CCC.
thanks.

 

[hal boyles]

is the sum function in the detail section of the report or in a footer
section?

 

[Matthias Langbein]

Hi,
unfortunatelly I don't know the correct expressions in english, so
I'll try to discribe and translate:

right-click on the "detail-section" ->"functioning and grouping" ->
select "field"="Bill-Number" -> select attribute "FOOTER"="YES"

and in this Footer (which appears now) is the sum function.

Hope you can help me...
Thx, Langi

 

[rob p]

Hi.
I need it to be in the detail. By the way, each record AAA,BBB and CCC is a
group. I found out by putting =SUM([amount]) in the group header it gives me
a correct total for the CCC record. I still would like to get it to work in
the detail section.
Thanks.

 

[Larry Linson]

Can you do this with a Totals Query? Create your Query, then in Query
Design view, on the menu "View | Totals" and group by what ever field
contains "AAA", "BBB", and "CCC".

Hi.
I need it to be in the detail. By the way, each record AAA,BBB and CCC is a
group. I found out by putting =SUM([amount]) in the group header it gives me
a correct total for the CCC record. I still would like to get it to work in
the detail section.
Thanks.

is the sum function in the detail section of the report or in a footer
section?