Getting Error message that I have never gotten before. 1

[ezamon]

I built a query that was working, now I have been getting an error message "Scaling of Decimal value resulted in data truncation," and my data is not coming back. I am using an ODBC connection, and I am not formating the decimal place. I am summing a formula that takes the 12 months of the last year and divided by 12. I was wondering if anyone else got this before and if there is a fix for this.
Thanks for the help

 

[sfreeman]

You probably need to convert one of your expressions explicitly to a double.

Try CDbl()...