"Numeric field overflow"

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a routine that has been running for seven months. One operation
is to append records to a table.

Today I get the error message:

"" Numeric field overflow ""

The information from Google search did not help.

Where do I look for an answer to this problem?

Thanks
 
Hi,
It sounds like you're tyring to enter too large a value in one of your fields.
For example, you may have a field defined as an Integer data type and are trying
to enter a value greater than 32,000.

Take a look at the data types of your fields and see what kind of values you're
trying to insert.
 
Thanks Dan,

I went back to the CSV file from which the data is sourced and it was
corrupt.

All is now well.

Cheers

Robin
 
Numeric field overflow should mean you have exceeded the limit of the
data type for a numeric some where. It is like putting 20 characters in
a field defined as 15 long. Typically this is not an issue with a
autonumber, because it can be so big, so you need to decide what is
happening to a number field. Do you have any yes/no fields you are
trying to put a number in? Maybe an INT field you are summarizing and
it is over flowing.
 
Back
Top