Yes. Your solution does work. I do the same thing in my apps.
>Jerry,
>
>Here's the statement I used:
>IIF(Denominator = 0, Alternamtive, Numerator/Denominator)
>
>I'm confused - doesn't the above statement check for a zero denominator
before the division, and not allow it to take place if the denominator is zero?
>
>
>>Cindy used the Immediate IF function. Another way is to check BEFORE the
>>division using an IF statement.
Mark McCasland
Midlothian, TX USA