We help IT Professionals succeed at work.

ms access + "scaling of decimal value resulted in data truncation"

Kirkeous
Kirkeous asked
on
Medium Priority
7,202 Views
Last Modified: 2012-05-10
Dear Gurus -

I have an MS Access 2003 front-end with a proprietary DBMS build which mimics SQL Server. It is called QuickBase. When I attempt to run a nested Union query in an Insert Query I received the following error message that halts the procedure:

"scaling of decimal value resulted in data truncation"

How can this be corrected!?

Thanks for your consideration.

Kirk
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
What's the value that you're trying to insert?
Commented:
What this means is that one of your values returned by the query have more numbers after a decimal point than you are able to insert into the destination table.  You will need to lessen the number of digits after your decimal point.  Check that the data type returned by the select statement matches that of the table you are trying to insert into.  If it isn't, then cast/convert it in your select so that it will come out matching the destination table's data type.  

Author

Commented:
I actually fixed this by changing the data type to Long Integer. Thanks!

Commented:
My comment is what led the poster to the correct solution.  "Check that the data type returned by the select statement matches that of the table you are trying to insert into."
Qlemo"Batchelor", Developer and EE Topic Advisor
CERTIFIED EXPERT
Top Expert 2015

Commented:
You referred to Decimal data type (which is obvious), the solution was to use a Long Int - where is the guidance here?

Commented:
The guidance was in exactly what I quoted from my statement above "Check that the data type returned by the select statement matches that of the table you are trying to insert into."  Don't worry about it.  I don't need to fight for points like this anyways.

Commented:
Post objection, the post by Swindle is considered appropriate as the result for a solution.The question is therefore restated for closure albeit with a change assignment.

WallyMod
Community Support Moderator