How do I show a grand total at the bottom of a report

[Guest]

I have a calculated field inside a report =([Quantity]*[ProductPrice]) to
give the product subtotal. I want to add up all those values at the bottom
of the report to show a report grand total. Does anyone know how to do this?

 

[Guest]

Create a field in the Report footer and write in the control source of this
field

=Sum([Quantity]*[ProductPrice])

 

[Guest]

It might be, that it's not placed on the report footer.

Try another way:
1. Create another field in the detail section
=[Quantity]*[ProductPrice]
The same as the original one, and set it properties to
Visible = False
Running Sum = Yes

2. On the report footer, create another field and write in it
=[Field name cretaed in section 1]



--
\\// Live Long and Prosper \\//
BS"D

I had a problem with that formula. the sum field I created would only
calculate the last Quantity*Product record and not a sum of all the
Quantity*Product recoreds in the report. Any ideas why? Thanks

Create a field in the Report footer and write in the control source of this
field

=Sum([Quantity]*[ProductPrice])
--
\\// Live Long and Prosper \\//
BS"D

I have a calculated field inside a report =([Quantity]*[ProductPrice]) to
give the product subtotal. I want to add up all those values at the bottom
of the report to show a report grand total. Does anyone know how to do this?

 

[Guest]

I had a problem with that formula. the sum field I created would only
calculate the last Quantity*Product record and not a sum of all the
Quantity*Product recoreds in the report. Any ideas why? Thanks

Create a field in the Report footer and write in the control source of this
field

=Sum([Quantity]*[ProductPrice])
--
\\// Live Long and Prosper \\//
BS"D

I have a calculated field inside a report =([Quantity]*[ProductPrice]) to
give the product subtotal. I want to add up all those values at the bottom
of the report to show a report grand total. Does anyone know how to do this?