formula problem

[Ryan0001]

im not sure which function or formula will be able to do this, but im sure u can help me out. ive got the folloing in a report:
Amount Income/Expenditure
....... ....................
....... .....................

I want to calculate the profit, i.e. Sum of income- sum of expenditure
ive tried IIf function, DLookup but i can seem to get it right..
any help is really appreciated

 

[humbleprogrammer]

Add a text box to the bottom of your report. Type the following in the properties Control Source:
=[Income]-[Expenditure] and set the Running Sum to Over All.

Hope this helps.