creating subtotals and grand totals on a report?

[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

 

[Marshall Barton]

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?

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)

 

[Duane Hookom]

In the detail section, use:
=quantity*productprice
In any Group or the Report Footer, use:
=Sum(quantity*productprice)

 

[Marshall Barton]

In the detail section, use:
=quantity*productprice
In any Group or the Report Footer, use:
=Sum(quantity*productprice)

The elegance of your solutions shines once again, Duane.

 

[Duane Hookom]

--
Duane Hookom
MS Access MVP
--

The elegance of your solutions shines once again, Duane.