Runtime Error: Arithmetic overflow error converting expression to data type int.
An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.
Computed columns are often the cause of arithmetic overflows. For example, consider the case where columns c1, c2, and c3 are defined as a data type of INTEGER. Further, assume that c3 is computed using the formula ([c1] * [c2]). If large values (such as 9999) are entered into c1 and c2, then the computation of c3 might exceed the allowable INTEGER limit. The size limitations for data types are determined by your database specification.
To correct this error
- Check the target column size for each column where the value is computed by a formula. Consider either expanding the size of the target column or reducing the allowable values in the formula's source columns.