if/then conditional statement help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christopher - 30 Nov 2005 22:03 GMT

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

Reply to this Message

Jeff Boyce - 30 Nov 2005 22:27 GMT

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>

>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
[quoted text clipped - 7 lines]
> I appreciate any help you can offer!
> chris

Reply to this Message