Solved

Help formatting a field in Access with a decimal point

Posted on 2013-02-01
4
502 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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 …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 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