Numeric Field Overflow Error Message

[Dan]

I have two separate queries that I run to update two
different tables, both of which are very large (one is
around 150,000 rows; one is around 500,000). 75% of the
time, I get a "Numeric Field Overflow" error message when
trying to run either query, and the table isn't updated.
The other 25% of the time, however, both queries run fine.
Any idea what this "Numeric Field Overflow" error message
is, and what can be done to minimize the number of times I
am getting it?

Thanks in advance for your help on this.


-Dan.

 

[Douglas J. Steele]

Usually Numeric Field Overflow is caused by having a number which is too
large for the field type in question. For example, the Integer data type can
only hold values between -32,768 and 32,767. If you try to put a number
outside of that range into an Integer field, you'll get that error.

 

[Douglas J. Steele]

Use a Long Integer. If need be, use the CLng function to convert your
numbers to Longs.