Formatting field if missing value

[WB786]

Ok I have this here in one of the post and now can't seem to find it.

One of my field is set to do some divisions. If the user forgets to enter a value or sometimes of the field can be blank for one the field I am getting #Num! in the totals field. How can I make it so it just shows a Zero or a blank.

Thanks in advance,
WB

 

[evilmousse]

tell us more about the fields.

what's the calculation in the sum field?

if it involves a dividend that might be
zero, use an iif statement for that case.

-g

 

[WB786]

In the control source of the field is this:
=[Payment]/[Balance]

How can I setup a IIf statment for this.

Thanks.
WB

 

[evilmousse]

make the source =
iif(balance = 0, 0, payment/balance)

it's a VERY handy function.
iif(condition, truepart, falsepart)


-g

 

[WB786]

I knew it was simple but wasn't sure how to make proper use of IFF. Thank you!!!

WB