scaling of decimal value resulted in data truncation

[Brett]

I am getting this error when trying to make table from a linked table (QuickBooks). It is an "Amount" number field and I can't figure out how to fix this problem.

[John W. Vinson]

Post by Brett
I am getting this error when trying to make table from a linked table (QuickBooks). It is an "Amount" number field and I can't figure out how to fix this problem.

More context please! What's the datatype of the linked record? What kind of
values does it contain (do you have numbers in the trillions, or more than
five decimal places)? What datatype are you attempting to create?

Note that an Access "Currency" datatype field is a 64 bit scaled huge integer;
it has four (exactly four, no more no fewer) decimal places and a range into
the trillions. An Access "Decmial" datatype is more flexible; you can define
the scale and the number of decimals within some rather broad ranges.

You might want to try running the query, ignore the warning, and check to see
if the data is in fact being incorporated correctly. If your QuickBooks data
contains dollars and cents, you may not care if the results are being
truncated at the $0.0001 level.