MS Access Append Queries Numeric field overflow

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!

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

Rolz wrote:
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!