If Statement in Report

[Nixx1401]

I have a report which is generated from a query. The report displays the individual name and the currency amount that person possess.

These are the fields: Transaction Number, Transaction Date, Name, ID, Amount Withdrawn, Amount Deposited and the currency is grouped. This formula here calculates the currency balance
=Sum([curDepositAmt])-Sum([curWithdrawAmt]) but if the withdrawn amount is blank it return no value for the currency balance

Can someone assist me with the formula. Basically I would like

If the withdrawn amount is blank display the deposit amount if not subtract the sum of deposits from sum of withdrawals

[pbaldy]

It sounds like the field is Null, in which case the Nz() function would be the way around it. Try that and see if it works for you (more info in Help if you're unfamiliar with the function).

[Nixx1401]

Can you elaborate a little more dont quite know how write the statement.

[pbaldy]

I mentioned looking in help because that should always be your first stop. There's a lot more information there.