How to Sum Total cost field in report

  • Thread starter Thread starter Gotoknow
  • Start date Start date
G

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.
 
Gotoknow said:
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.
Click to expand...


The report footer text box should use an expression like:
=Sum(cost1) + Sum(cost2) + Sum(cost3)
 
Thank you!! It worked.
--
Thank you,
Gotoknow


Marshall Barton said:
Gotoknow said:
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.
Click to expand...


The report footer text box should use an expression like:
=Sum(cost1) + Sum(cost2) + Sum(cost3)
Click to expand...
 
Back
Top