OverFlow in My Reports! Help!!!!

[Epeh Daniel]

HI,
I designed my report and it was working alright. Recently
i suppose there is something i did not do properly and
anytime i try to view my report in page design view or
print it. I get this error message "Overflow" Click OK!
However i continue to see the report in Design mode.
Can anyone help?
Thanks

 

[SA]

Epeh:

There are to primary causes of "Overflow" occuring in reports. 90% of the
time its a result of a divide by zero or divide by null problem. If you
have either division occurring in the report's query or in the report itself
in a control's control source, then modify the calculation to test for zero
and null in the denominator as in:

=IIF (IsNull([MyDenomField] or [MyDenomField] =0, 0,
[MyNumField]/[MyDenomField])

Otherwise it will occur if you assign a value to a variable in code in your
which is too big for the varialble e.g. assigning 300 to a variable that is
a byte variable.