How do I change my dataype to Currency without adding extra zeroes

S

Stephanie Williams

My data is extracted from a server and formatted something like
"0000000087103." When I change the dataype to currency, it displays the
amount as "$8,7103.00" instead of "$871.03." I have tried all variations of
adjusting the datatype to Number, changing the FieldSize from Integers, adn
adjusting the formattig and decimal places, but nothing works. It either
does not add the decimals at all or removes the digits following the
decimals.
 
K

Ken Snell [MVP]

The conversion to Currency doesn't include the decimal values in your number
because ACCESS sees it as a whole number.

After you convert the field type, then run an Update query to divide all the
values by 100:

UPDATE TableName
SET CurrencyField = CurrencyField/100;
 
Top