Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

Help formatting a field in Access with a decimal point

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
joylene6
Asked:
joylene6
  • 2
2 Solutions
 
peter57rCommented:
format(fieldname/100,"#0.00")
0
 
hnasrCommented:
Try:
Unit_COST/100
0
 
joylene6Author Commented:
yes!! Field name/100 worked!

Thanks!!
0
 
hnasrCommented:
Welcome!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now