Sum in a report

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

Guest

Hi,

I have a report with some numeric values listed, but I need to make a sum of
them all and display it at the end.
How can I do that?

Thanks in advance.
 
David,
In the report footer, place an unbound text control eith a ControlSource
of
=Sum(YourNumericField1Name)
will give you a total for one field over the whole report.

Then, in the report footer you can add the sum of several fields.
Using another unbound text control with a ControlSource of...
=Sum(YourNumericField1Name) + Sum(YourNumericField2Name) etc...

hth
Al Camp
 
Back
Top