Change number format

  • Thread starter Thread starter jlo
  • Start date Start date
J

jlo

Is there a way to change 469 to $4.69 in a query? When I change the
properties to currency I get $469.00.

The data was exported into Access and the figures have no decimals or dollar
signs.

I can't tell you how many times I have used this site and found answers to
most of my issues. Thank you in advance for your time.
 
In query design view, type an expression like this into a blank column in
the Field row:
[Amount] / 100
substituting your field name for Amount.

If you really want to convert to Currency, try:
CCur(Nz([Amount] / 100))
 
Back
Top