Convert value from cents to dollars

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?
wardjameAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tbsgadiConnect With a Mentor Commented:
Hi,
There's no easy way to bring in the data straight to a table as Dollars.
You'll need to bring them in as cents & then create a query with a field TransactionDollars:transactionamount/100

Good Luck

Gary
0
 
William ElliottSr Tech GuruCommented:
price * 100
0
 
William ElliottSr Tech GuruCommented:
err
price / 100
0
All Courses

From novice to tech pro — start learning today.