getting overflow error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, there
when i try to open a query I get "Overflow" error.... is
there anyone out-there who konws how to fix this error..

Thanks
 
I'm getting the same error. All the message says is "Overflow" with the OK
button. I'm running a query that computes a bunch of percentages.
Yesterday, it ran fine. Today, nothing.
 
Overflow typically happens when you have a field or variable that is
declared as an integer. An integer can hold numbers only up to 32, 768.
Thus, your query can break anytime you try to put any number larger than
this into that field or variable.

So, you got lucky yesterday. Today, not so lucky. Either restructure your
table to use a Long Integer (or Double), or verify that the numbers sent to
the field/variable are supposed to be larger than 32,768.
 
I investigated my table, the numbers entered appear to be ok. I wondered
about some of the entries that were entered as zero & thought that maybe I
was dividing by zero. So I cleared all of those & just left the fields
blank. It worked (I think). Hey, thanks for the info!

bbarkman
 
As I am sure Steve knows, you sometimes get the Overflow error when you divide
by zero. It doesn't make sense as an error message, but that is what can happen.
 
Back
Top