Solved

Help formatting a field in Access with a decimal point

Posted on 2013-02-01
4
494 Views
Last Modified: 2013-02-01
I am attempting to format a field in an access query.  It is a price field.

I think I need to ADD 2 leading 0's then add in the decimal place.

Example in the field I am getting these results:

3 ---- should be 0.03
12 ---- should be 0.12
1314 --- should be 13.14

 I tried various FORMATs like .....   Expr2: Format([UNIT_COST],"00")  and Expr2: Format([UNIT_COST],"#.00") ... I just cant get it to work....

I also tried to format this as a number.... and use decimal places.....

Can you offer any suggestions?

I have attached the database and a picture of what I need the results to be
PRICE-REPORT-.accdb
EXPECTED-RESULTS.jpg
0
Comment
Question by:joylene6
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 300 total points
ID: 38845715
format(fieldname/100,"#0.00")
0
 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 200 total points
ID: 38845726
Try:
Unit_COST/100
0
 
LVL 1

Author Comment

by:joylene6
ID: 38845742
yes!! Field name/100 worked!

Thanks!!
0
 
LVL 30

Expert Comment

by:hnasr
ID: 38845855
Welcome!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
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 …

773 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