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

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

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?
 
Create a field in the Report footer and write in the control source of this
field

=Sum([Quantity]*[ProductPrice])
 
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


nikki said:
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

Ofer said:
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


nikki said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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

Ofer said:
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


nikki said:
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?
Click to expand...
Click to expand...
 
Back
Top