MICROSOFT JET ERROR

[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!

 

[Van T. Dinh]

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?

 

[Guest]

So use the round([field],2) function when writing a formula in your query.
It will make the data more manageable.