Getting "Overflow" error message while running Make-Table Query

K

Kmart9999

This query has previously worked, but is now showing the error when I have it
look at different data. Is it purely a "too much data" issue or is there a
way to resolve it?
 
J

John W. Vinson/MVP

Kmart9999 said:
This query has previously worked, but is now showing the error when I have
it
look at different data. Is it purely a "too much data" issue or is there
a
way to resolve it?
Click to expand...

No, an Overflow error means that you're doing some sort of mathematical
calculation which is generating a number larger than Access (or any Office
program) can store in the specified datatype.

Could you post the SQL of the query? Does it in fact include any math
expressions, in particular multiplications (multiplying two large numbers)
or divisions (dividing a large number by a small one)?
 
K

Kmart9999

Thanks for the feedback. I actually went back into the query and tweaked it,
and I no longer am having that error. Thanks again.
 
Top