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

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

Guest

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?
 
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)?
 
Thanks for the feedback. I actually went back into the query and tweaked it,
and I no longer am having that error. Thanks again.
 
Back
Top