Query Message

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

Guest

I have written a query for an access database and every time I try to run it
I get the message "overflow". I am unsure what this message means and how to
resolve it, any suggestions would be gratefully accepted.

Thanks

Nick
 
You can get that message when you are dividing by zero, summing a field that
is defined as integer and the sum exceeds 32767, and other causes.

You could post your SQL statement if the above doesn't help you to solve
your problem.
 
Nick,

An overflow means you've tried to put a numeric value into a data type that
isn't big enough to handle it. For example, the following will generate an
overflow:
Dim x As Integer
x = 32768

In this case, changing x to a Long will fix the problem.
Dim x As Long
x = 32768

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top