access report grand total

[rbiii]

=[UnitPrice]/1000*[UnitsInStock]
the above is the formula for a value of an individual item on a report.
How do I get a grand total of all of these values of individual items at the end of the report?

 

[MakeItSo]

Have an invisible textbox in your details section set to
=[UnitPrice]/1000*[UnitsInStock]
set its "running sum" property to "Group"
Set your GrandTotal-field to =[running sum field]

The GrandTotal will display the current GrandTotal up to the current page. (So overall total on last page)

Cheers,
Andy



Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[SeeThru]

The other option is include the formula as a culculated field in the query the report is based on. For the detail, data source is the calculated field name. For the footer, it is sum([calcfield])

I personally prefer that way.