Aug 17 2004, 04:29 PM
I need to convert a currency field in order to append it to another table. I'm trying to do this in a query, but I would settle for making a table and then appending.
The problem is I cannot convert the currency field into a decimal with 5 precision and 4 scale. I cannot get Access (or Excel) to drop the extra data it is storing for this field. I get the follwoing error:
The decimal field's precision is too small to accept the numeric you attempted to add
Aug 17 2004, 05:01 PM
Are any of your currency values greater than or equal to 10?
I ask because I believe Precision 5 and Scale 4 would look like this: 0.0000
A value greater than 9.9999 would not fit in a field of this data type.
If the above is the case, try a larger Precision. For example, Precision 10 and Scale 5 would look like this: 000,000.0000 (which would hold a number as large as 999,999.9999)
Aug 17 2004, 05:16 PM
That's what I was not understanding. I multiplied the currency figure by .01 and I'm golden.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here