What is overflow?

[Guest]

When trying to execute a query in Access, I get the error message, "Overflow",
why am I getting this error?

 

[Guest]

hard to say. i usually get the overflow error when i have
a data type set up wrong. maybe as an integer when it
should be a double.

 

[Guest]

Hi Belle,

As the previous post mentions, this is often caused by calculating a value
that does not fit into the fields number type. In queries, Access will
define the output number type based on the types of numbers being used in the
expression, but this isn't always what you want. You can use the numeric
conversion functions, such as CLng() and CDbl() to force the number field
size to what you want.

One other idea, I believe that dividing by 0 can also cause the overflow
error.

HTH, Ted Allen

 

[John Vinson]

When trying to execute a query in Access, I get the error message, "Overflow",
why am I getting this error?

Overflow means that Access is trying to calculate a numeric value that
is larger than can be accommodated in the numeric datatype that you're
using: for instance, an Integer type number can get up to 32767 but no
larger. This will usually happen when you've made some sort of mistake
in a calculated expression, such as dividing a large number by a very
small one. Could you describe the query you're trying to create?

John W. Vinson[MVP]