Change number format

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.
 
A

Allen Browne

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMATTING RESULTS IN CALCULATED FIELD 4
change format in make table query 2
Number Format not working 2
Number formatting in export 1
limiting decimals in query results 2
How do I get Access to append the exact amount with decimals? 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
calculated currency field sorts like text instead of numeric 4

Top