Query Message

[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

 

[John Spencer]

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.

 

[Graham R Seach]

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