Using Subtraction in a report

[vnfoster]

Any help or guidance on where to look would be great.

On my report I have a calculated field for a monthly total cost that reads sum=([total cost]) what I would like to do is subtract this from a field in my table called "amount funded".

Thank you for your time

 

[llkhoutx]

The summed field has a name e.g. SumName; the record source of the "amount funded" should be "=[amount funded] - [SumName]" without the quotation marks.

As a matter of good practice, do not ever have blank spaces in control or field names as it causes a world of grief in building SQL strings and VBA code.