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