I got this message when I ran a select query. What does it mean? What do I
do about it? I notice that some of my records have a #error.
Well, it's possible that it means just what it says: that you tried to
put three quarts of milk into a half-gallon bottle.
If your Decimal field has a scale of 2, that means you can have only
two numbers after the decimal point. If you try to store 4.123154 into
this field, the ..3154 cannot be handled, and you'll get... data
truncation. It will store 4.12 and truncate the number there.
The #Error might mean that you're trying to store a number which won't
fit at all - e.g. 312341156.1324 into a Decimal field with precision 5
(or any precision less than 13).
John W. Vinson[MVP]