Help!

How do I divide by zero on my form (in a text box).

That is, how do I carry out a division problem when the denominator is
zero?

Thanks!,

John

You need to check to see if the denominator is zero, as you can't divide by
zero otherwise an overflow error will result. You can use an IIF statement,
something like:

=IIf([denominator_field] = 0, 0, [numerator_field]/[denominator_field])

Hope this helps,


"zufie" <john.marruffo (AT) illinois (DOT) gov> wrote