Insert decimal into number field

[JackieEVSC]

I'm pulling data from a table that I cannot change, so I have to format it through a query. The field is a number field. I'm needing the value of "500" to format as $5.00.


I've tried changing the field type to currency, but it adds two zero's on the end ... so instead of "$5.00", I get "$500.00". I've tried to tell it to use two places after the decimal, but since there is no decimal point, I still just get "500". I've tried ###.## ... I still get "500". I've tried $###.##. Same thing. $000.00 ... same thing.


I know it's simple, but I cannot figure out how to format this!! Any help would be appreciated.

Jackie

[John_G]

If it's always two decimal places with an implied decimal point, just divide by 100 and display as currency:

format([value]/100, "Currency")

so format(103228/100.,"currency") will give you $1,032.28

[Bob Fitz]

How about formatting as currency and divide by 100

[JackieEVSC]

I knew it was simple. Thank you very much