Calculating Total Cost

[2 Advanced]

Hi, producing my reports i've got a list of cost. I used the method:

=SUM([Cost]) in a text box using a Control Source, yet it brings up an error... y?

one of the title is: Cost

Which im collecting the total cost

 

[Vassago]

What error are you recieving and where are you placing this field in the report?

 

[2 Advanced]

#Error


This the error i get

 

[Rich]

You have to repeat the calculation =Sum([quantity]*[cost])

 

[2 Advanced]

Im not calculating between quantity, im calculating the fields which contain the cost and i want the total cost on the report:

=SUM([Cost])

but brings up error..

 

[Rich]

Then your textbox is in the wrong footer, use the Report footer

 

[2 Advanced]

Ah Thank you