Sum Calculated Field

S

Supe

I have a report with a Region Header that shows has the item, item shipment
total and item cost in the Item Footer(Put in Item Footer to get a total of
all shipments). I added a text box that calculates the Total Amount by item
multiplying the Shipment Total. I want to have. I want to put a Sum in the
Region Footer that will add up all the Total AMounts of the items to give me
a Grand Total for that region. I gave the Text Box I created to calculate
the cost in the Item Footer the name of TOTALCOST. Thought I could put
=Sum([TOTALCOST]) in the Region footer to get the total, but when I run the
report I get an Enter Paramter Value box that list TOTAL COST. Please advise.
 
D

Duane Hookom

You can't sum controls. You can possibly sum the calculation used in the
TOTALCOST text box. Since you didn't provide the control source of TOTALCOST,
I can't be sure if it will work.
 

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