Question on Iff Statement

  • Thread starter Thread starter John Lane
  • Start date Start date
J

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.
 
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
 
Back
Top