How to Sum Total cost field in report

[Gotoknow]

Hi.

I have 4 fields set up in a table and on the report as shown below
Cost 1 Cost 2 Cost 3 Total Cost
$1.00 $2.00 $3.00 $6.00
$1.00 $2.00 $3.00 $6.00

The Total Cost field is working fine.

What I wish to do is have a field or area at the very end of the report that
summates the entire Total Cost Field. Shown above the answer would be $12.00.
I've tried the following in Report design view.=Sum([Total Cost) and placed
this formula in a text unbound control box in the report footer. I also
tried Specifing Over Group with this formula. When I go to Print Preview the
Label shows up but the calulation always shows 0. I also tried using the Sum
function you click on in the grouping and totals area of the design tab. It
seems to only want to count records but not Summate. All fields are
formatted as Currancy. I'm using Access 2007.

 

[Marshall Barton]

I have 4 fields set up in a table and on the report as shown below
Cost 1 Cost 2 Cost 3 Total Cost
$1.00 $2.00 $3.00 $6.00
$1.00 $2.00 $3.00 $6.00

The Total Cost field is working fine.

What I wish to do is have a field or area at the very end of the report that
summates the entire Total Cost Field. Shown above the answer would be $12.00.
I've tried the following in Report design view.=Sum([Total Cost) and placed
this formula in a text unbound control box in the report footer. I also
tried Specifing Over Group with this formula. When I go to Print Preview the
Label shows up but the calulation always shows 0. I also tried using the Sum
function you click on in the grouping and totals area of the design tab. It
seems to only want to count records but not Summate. All fields are
formatted as Currancy. I'm using Access 2007.

The report footer text box should use an expression like:
=Sum(cost1) + Sum(cost2) + Sum(cost3)

 

[Gotoknow]

Thank you!! It worked.
--
Thank you,
Gotoknow

I have 4 fields set up in a table and on the report as shown below
Cost 1 Cost 2 Cost 3 Total Cost
$1.00 $2.00 $3.00 $6.00
$1.00 $2.00 $3.00 $6.00

The Total Cost field is working fine.

What I wish to do is have a field or area at the very end of the report that
summates the entire Total Cost Field. Shown above the answer would be $12.00.
I've tried the following in Report design view.=Sum([Total Cost) and placed
this formula in a text unbound control box in the report footer. I also
tried Specifing Over Group with this formula. When I go to Print Preview the
Label shows up but the calulation always shows 0. I also tried using the Sum
function you click on in the grouping and totals area of the design tab. It
seems to only want to count records but not Summate. All fields are
formatted as Currancy. I'm using Access 2007.

The report footer text box should use an expression like:
=Sum(cost1) + Sum(cost2) + Sum(cost3)