Numeric Field Overflow

[Mr. T]

I have created some Make Table Queries. They worked at
first, but now I get an error that indicates I have a
Numeric Field Overflow when I try to run the query. How
do I prevent this message?

 

[John Vinson]

I have created some Make Table Queries. They worked at
first, but now I get an error that indicates I have a
Numeric Field Overflow when I try to run the query. How
do I prevent this message?

By making sure that you're not inserting a value larger than the field
will contain (65536 for Integer, 2147483647 for Long Integer).

Why all the make-table queries? They are VERY RARELY necessary, since
you can base a Form, a Report, or an Export on a select query!