Total or sum in Continuous from

[Guest]

I have created a subreport in a form with a continuous format. In the footer
of the sub form I need a total or the sum of a field being calculated.

How would I get that total or sum? When I enter =sum([Cost]) I get an error.

Thanks...

 

[Al Camp]

Jeff,
Is Cost the result of a calculation on the report... like Cost =
Price*Qty
You can not add a calculated field of a report in the report footer.
In the query behind your report, create a calculated column like this...
using my example above...
Cost : [Price] * [Qty]
Now Cost (which is now a bound field) can be placed in the report detail,
and summed in any footer with...
=Sum(Cost)
-
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions