I have an online report and on occasion i have to computer 0/0 and i keep running in an overflow error. I need this to computer to 0 for calculations later on so i cannot use On Error Resume Next
you mean you are dividing zero by zero? why not do it conditionally?<BR><BR>If a = 0 or b = 0 then<BR> result = 0<BR>else<BR> result = a/b<BR>end if<BR>
.. 1.<BR><BR>Because anything divided by 1 is the same number.