add total value

[nim180]

Hi everyone, can someone help me with the following, i have a form that has 2 textfields, depending on whats entered into the textfields it runs a report and generates all he required values, this part works fine. When the report is generated it may bring up a list of lets say 100 customers with all their details. For each customer theres a field called "totalcost", now what im trying to do is add all the customers "totalcost" thats generated on the report, im trying to do this by placing a textfield onto the footer of the report and using different combinations of DSUM or SUM but neither work. Can someone help me with this?

Thank you
Nim

 

[nim180]

problem solved i was puting the textbox in the page footer instead of the report footer!