Question on Iff Statement

[John Lane]

Using Access 2007, I have the expression "IIf(IsNull(Sum([Deposit
Amount])),0,Sum([Deposit Amount]))" in a query. All the data is null, but I
am not geting the "0" output. I don't se what I am doing wrong. The field
"Deposit Amount" is a Currency field. Thanks.

 

[Jeff Boyce]

John

"All the data is null" ... how do you know this?

If the field allows zero-length strings, they might be 'empty', but not
null.

Regards

Jeff Boyce
Microsoft Office/Access MVP