How to Sum Total cost field in report


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.
 
Ad

Advertisements

M

Marshall Barton

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.


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

Advertisements

G

Gotoknow

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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top