Overflow Message

[Jim McD.]

I'm trying to open a report with a query as the record source, but I keep
receiving the error message, "Overflow".

Any advice/suggestions as to how I can correct this problem?

Chris

 

[SA]

Jim:

Look in the query that underlies the report. Overflow 999.9% of the time is
a result of a divide by zero error in the query. If you are dividing in the
query (or the report say in a calculated control), then use an IIF statement
to recectify as in

IIF([SomeFieldAsDenominator]<>0,
[SomeFieldAsNumerator]/[SomeFieldAsDenominator],0)