MICROSOFT JET ERROR

J

Jenn

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

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?
 
R

Robert K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
#error - Blank 3
Report Group Footer DLookUp 0
Using project as a resource tracker 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Scaling results in data truncation 2
The Microsoft Jet database engine does not recognise... 4
Date Time decimal value help please 1

Top