Group Sum

  • Thread starter Thread starter rob p
  • Start date Start date
R

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.
 
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
 
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.
 
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".

rob p said:
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.



hal boyles said:
is the sum function in the detail section of the report or in a footer
section?
Click to expand...
Click to expand...
 
Back
Top