Overflow when field is Zero

[matthewnsarah07]

Me.TotalRlppe = ([rlTotalCompppe] / [rlTotalRecppe]) * 100

I have the above as part on On Load event to display results on a form - however on some occasions both fields used in the above calculation can be zero. Obvioulsy when this is the case I get an overflow error

Can I add anything to the code to get round this?

 

[pbaldy]

You can use an IIf() function to test the field for zero; return zero if so, your calculation if not.