"overflow" error message

  • Thread starter Thread starter rroper
  • Start date Start date
R

rroper

I have changed the source control on a saved query to
obtain a new report on different "like" data set and when
I go to preview I get an overflow message. Can anyone
tell me what this might be referring to and where I can
look to fix?
 
You haven't given us much detail to go on, but an overflow can occur when
the data type is not large enough for the result of a calculation.

As an example, open the immediate window (ctrl+G), and enter:
? 200 * 200
By default, Access uses a signed Integer, which cannot contain anything
bigger than 32767, so this calculation causes an overflow. The solution is
to convert one of the numbers into a larger type such as a Long. Try:
? CLng(200) * 200

Hopefully you will be able to track down the calculation that is
overflowing.
 
Thanks for that explanation. I fixed the problem, the
problem I had in explaning was I did not know which field
was causing the problem. Your explanation that it was a
calculated field helped tremendously. Rhonda
 
Back
Top