Numeric Field Overflow

  • Thread starter Thread starter Mr. T
  • Start date Start date
M

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?
 
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?
Click to expand...

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!
 
Back
Top