Numeric field overflow error

G

Guest

Hi,

When I tried to run a macro to append data, it gave me this error.

Numeric field overflow.

What is this error and what to do to resolve it? Thanks.
 
D

Douglas J. Steele

You're trying to put too big a number for the data type of the field.

For example, Integers can only be values between -32,768 and 32,767. If you
try to put a value of 32,768 into an Integer field, you'll get an overflow.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow Error 5
Linking table gets numeric field overflow 2
Numeric Field Overflow when appending date - how to convert it to text 1
Why not numeric overflows? 5
Numeric Field Overflow 1
Numeric Overflow Error 4
TransText Method 1
Overflow error when appending data to SQL from Access 1

Top