Calculating a value in a report

[KCA]

I have a problem with calculating a total in my report. I've created a report with 10 separate fields (each calculated totals of a number of records which match certain criteria). Up to now all works fine. Next thing I want to do is to make the total of the values in these fields. This is not working. I tried to create a text box in the report footer section which has the controlsource "=[total1]+[total2]+[total3]..." With this I get no result. The new field remains empty.
What am I doing wrong ??

 

[KCA]

Thanks, one additional question, how do I use this ? I mean, create some VBA code or enter it in a text box ? I'm not really familiar with code...

 

[Rich]

Replace the example you gave with the one Pat posted.

 

[KCA]

Works great, thanks for the quick reply.