Total sum

[Guest]

How can I get the total sum of dollars to come up at the end of a report?

Thanks
Mike

 

[Al Camp]

Mike,
Create an unbounmd text control with a ControlSource of (use your own
field name)
=Sum([Dollars])
in the Report Footer.

Your [Dollars] field should be a bound field, and not the result of a
calculation performed on the report itself.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Duane Hookom]

Add a text box in your report footer with a control source like:
=Sum([Expression from your report record source])

 

[Guest]

If the data are calculated, what do you need to do?

Thx.

Mike,
Create an unbounmd text control with a ControlSource of (use your own
field name)
=Sum([Dollars])
in the Report Footer.

Your [Dollars] field should be a bound field, and not the result of a
calculation performed on the report itself.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

How can I get the total sum of dollars to come up at the end of a report?

Thanks
Mike

 

[Al Camp]

Include the calculation in the query behind the report, associated ("bound")
to a name. Example...
LineTotal = [Price] * [Qty]
Now, "bound" field LineTotal can be summed in any group or report footer
=Sum(LineTotal)

Had you just placed an unbound text control named LineTotal on the report
with
= [Price] * [Qty]
that = Sum([LineTotal]) would give an #error when summing.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

If the data are calculated, what do you need to do?

Thx.

Mike,
Create an unbounmd text control with a ControlSource of (use your own
field name)
=Sum([Dollars])
in the Report Footer.

Your [Dollars] field should be a bound field, and not the result of a
calculation performed on the report itself.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

How can I get the total sum of dollars to come up at the end of a
report?

Thanks
Mike