creating subtotals and grand totals on a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I feel like I have tried everything!
All I want to do is calculate a subtotal on a report, and then add up all
those totals for a grand total at the bottom.

My report contains: Quantity, Product, and ProductPrice
I want to subtotal each line (quantity*productprice) and then sum all those
calculations into a grand total at the bottom. Does anyone know how to make
this happen?
-Thanks
 
nikki said:
I feel like I have tried everything!
All I want to do is calculate a subtotal on a report, and then add up all
those totals for a grand total at the bottom.

My report contains: Quantity, Product, and ProductPrice
I want to subtotal each line (quantity*productprice) and then sum all those
calculations into a grand total at the bottom. Does anyone know how to make
this happen?
Click to expand...


Add a text box to the detail section and set its control
source expression to =quantity * productprice

Then add a text box to the report footer section using this
expression =Sum(quantity * productprice)
 
In the detail section, use:
=quantity*productprice
In any Group or the Report Footer, use:
=Sum(quantity*productprice)
 
Duane said:
In the detail section, use:
=quantity*productprice
In any Group or the Report Footer, use:
=Sum(quantity*productprice)
Click to expand...


The elegance of your solutions shines once again, Duane.
 
Back
Top