Convert value from cents to dollars
Posted on 2007-11-29
I am using ms access to generate reports for our online transactions. My database uses linked csv tables which are downloaded periodically to update the data. My problem is that the table my online credit card processing provider supplies me with reports the transaction amount in cents. When I setup the linked table if I check the field as Currency I do not get the decimal I want. ie $1.25 comes through as $125. I see no way to tell access that I want a decimal before the last two digits. Any suggestions?