Total or sum in Continuous from

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

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...
 
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
 
Back
Top