MICROSOFT JET ERROR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am receiving the following error when I run a query:

Scaling of decimal value resulted in data truncation.

Can anyone tell me in plain english what this means? My query is setup to
request a date range. If I request 1 or 2 months of information, I get
results. But if I request more than that, I get the error message above.

Any help or ideas would be greatly appreciated!
 
Scaling of decimal value resulted in data truncation. (Error 3758)
This error occurs when the data being updated or inserted into a DECIMAL
data type does not match the defined scale and precision of the column.

Does that help or muddle up a bit more?
 
So use the round([field],2) function when writing a formula in your query.
It will make the data more manageable.
 
Back
Top