Subtotals in Group Headers

  • Thread starter Thread starter John Michl
  • Start date Start date
J

John Michl

Is it possible to have a subtotal in a group header that totals the groups
and/or detail below it? I need a report such as the following.

Units Sales
Total Apples 10 $20
Red Delicious 3 $5
Golden Delicious 7 $15

Total Oranges 6 $12
Navel 4 $8
Velencia 2 $4

Total Fruit 16 $32


Thanks - John Michl
 
Yes you can. In your group header add 2 unbound controls.
Set the control source to
=sum([Units])
=sum([sales])

don't forget to format the controls

Jim
 
Thanks, that was easy enough.


Jim/Chris said:
Yes you can. In your group header add 2 unbound controls.
Set the control source to
=sum([Units])
=sum([sales])

don't forget to format the controls

Jim
-----Original Message-----
Is it possible to have a subtotal in a group header that totals the groups
and/or detail below it? I need a report such as the following.

Units Sales
Total Apples 10 $20
Red Delicious 3 $5
Golden Delicious 7 $15

Total Oranges 6 $12
Navel 4 $8
Velencia 2 $4

Total Fruit 16 $32


Thanks - John Michl


.
Click to expand...
Click to expand...
 
Back
Top