Hello,

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

Any thoughts?

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)

THANK YOU!!!!

That's what I was not understanding. I multiplied the currency figure by .01 and I'm golden.

GRACIAS!