Problem with #DIV/0 error, STILL

[Mike Hughes]

I have the following control source in a text box.
When there is a CURRENT OWED amount field there is no problem but
when there is no amount in the CURRENT OWED field I get the error #DIV/0

=Sum([CURR PAID])/Sum([CURR OWED])

If the CURR OWED = 0
I GET #DIV/0 ERROR

Would someone show me how to correct this so the result would be 0?

Thanks, Mike

 

[vbaInet]

Mike, I'm almost certain you've been shown how to avoid Div/0 errors, but here

=Sum([CURR PAID])/IIF(Sum([CURR OWED]) = 0, 1, Sum([CURR OWED]))

 

[Mike Hughes]

Now I do get an amount reather than Div/0 error, but the % is showing up as the ARREARS PAID amount. I have attached a screen shot.

 

[vbaInet]

Like so,

=IIF(Sum([CURR OWED]) = 0, 0, Sum([CURR PAID])/Sum([CURR OWED]))

 

[Mike Hughes]

That worked! thanks