Overflow Message

  • Thread starter Thread starter Jim McD.
  • Start date Start date
J

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
 
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)
 
Back
Top