if/then conditional statement help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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