MS Access Append Queries Numeric field overflow

R

Rolz

Hi, Im encountering Numeric field overflow error whenever I run Append
Queries on the fourth times. Could you help me resolve the problem?I've
already checked the data type..the table and the source data types are the
same..Thank you!
 
J

John Spencer

This usually means you have a number field typed as Integer (Max size 32765)
and are trying to stuff too large a number into the field. Often happens if
you are summing an integer field and trying to put that Sum into another
integer field.

Another possible problem is a division by zero error that is being improperly
reported as an overflow error.

Without knowing your query or your data types the above is speculation.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

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
Numeric Field Overflow 1
MS Project Center-Autolink column fields 0
Numeric field overflow 0
Fixing Numeric Overflow 1
Numeric Field Overflow Error for Macro 4
Linked Tables - adding field and getting overflow error 1
The Numeric Field Overflow error with linked tables 2

Top