Solved

Help formatting a field in Access with a decimal point

Posted on 2013-02-01
4
498 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 the scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

740 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