Sum in access report (1 Viewer)

[DenisCooper]

Hi,

I have a report generated by a query.

The query shows the total rent collected per property and the total expense per property. It then has a sum in it to work out the total profit - SUM(rent collected - expense paid.).

This works fine and the report works fine. But i want to add the totals in the bottom of the report.

So i have three unbound text boxes, one for each column. And the control source is

Sum([rentcollected])
Sum([expensepaid])

these two work fine, but then i have tried to work out the total profit but can't get this working. If i do Sum([profi]) this doesn't generate the real profit as it just totals the profit column which might have negatives.

If i put in sum([txtTotalRentCollected]-[txtTotalExpensePaid]) then when running the report it prompts for the values of the text boxes - these are the names of the text boxes the totals are calculated in.

Any help appreciated.

Thanks

 

[pbaldy]

Try

Sum([rentcollected] -[expensepaid])