Query with blank value won't compute

[willkr]

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

[June7]

That is not a query, it is expression in textbox.

What happens?

"" is an empty string and not the same as Null. A number field cannot have empty string. If these fields are result of a calculation, why would they be empty string?

If field is Null, DSum should return Null.

[Welshgasman]

Why would they be blank and not 0?

[CJ_London]

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 = "")?

just to clarify - what/which fields? The ones you are trying to sum?