formula question

[Samual]

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

 

[Rich]

=Sum([Income]-[Expenditure])

 

[Samual]

No...let me just make it clearer: the amount field has the totals, whilst the income/expenditure field only says whether it is income or expenditure

 

[Rich]

=Sum(Iif([SomeField]="Income",[MyField],0)-Sum(Iif([SomeField]="Expenditure",[MyField],0)

 

[Samual]

THANKS alot...it worked