Improve company productivity with a Business Account.Sign Up

x
?
Solved

Convert value from cents to dollars

Posted on 2007-11-29
3
Medium Priority
?
13,139 Views
Last Modified: 2008-02-01
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?
0
Comment
Question by:wardjame
  • 2
3 Comments
 
LVL 19

Expert Comment

by:William Elliott
ID: 20380031
price * 100
0
 
LVL 19

Expert Comment

by:William Elliott
ID: 20380032
err
price / 100
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 750 total points
ID: 20380570
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

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question