if/then conditional statement help

[christopher]

I have an output field in my db that lists [SumOfBALANCE] however, when
performing a later function it turns out that if this field is blank I get a
blank result. The fields won't sum a # field w/ a blank field.

How do I create an if [SumOfBALANCE] = "blank", then [SumOfBALANCE] =0 so
that it actually writes the 0 to my field?

I appreciate any help you can offer!
chris

 

[Jeff Boyce]

Consider using the Nz() function in a query to return a zero if the field is
null.

NOTE: I couldn't tell if you mean a zero-length string or null when you say
"blank". They aren't the same.

Regards

Jeff Boyce
<Office/Access MVP>