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

[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?

 

[John W. Vinson/MVP]

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?

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)?

 

[Guest]

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