scaling of decimal value resulted in data truncation


B

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.
 
Ad

Advertisements

J

John W. Vinson

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.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 

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

Top