I have a query that looks like this:
=Nz(DSum("[SavingsDepBal]","qrySavingsDepositGrandTotal"),0)-Nz(DSum("[SavingsWithdrawTot]","qrySavingsWithdrawalGrandTotal"),0)
It works fine as long as the SavingsDepBal 0r SavingsWithdrawTot are not blank. What do I have to do to make this work with a blank field (field = "")?
willkr