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
LVL 1
joylene6Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
peter57rConnect With a Mentor Commented:
format(fieldname/100,"#0.00")
0
 
hnasrConnect With a Mentor Commented:
Try:
Unit_COST/100
0
 
joylene6Author Commented:
yes!! Field name/100 worked!

Thanks!!
0
 
hnasrCommented:
Welcome!
0
All Courses

From novice to tech pro — start learning today.