Include zero after decimal in text string

[inhops]

I have an Access query that calculates a cost. I then need to append USD after the cost. I want a calculation that results in 24.7 to end up as a text string "24.70 USD". It is appearing as "24.7 USD". I tried doing the calculation in a separate field with the field formatted as Fixed:2 and then using this field in the - but it still doesn't work.

1st attempt:
FormattedAmt: Round(Price*1.08,2) & " USD"
2nd attempt:
Amt: Round(Price*1.08,2) - field is formatted as Fixed:2
FormattedAmt: Amt & " USD"

I was trying to do it all in a query, but if I need to add a function, I can do that. Other than converting each position of the number to text, is there a way to do this?



Thanks for the help!

[JoeM]

Use the FORMAT function. It coerces it to Text, so it retains trailing zeroes, i.e.

FormattedAmt: FORMAT(ROUND([Price]*1.08,2),"0.00") & " USD"

[inhops]

Thank you so much for the quick reply. This is perfect! Now I get "24.70 USD". Such an easy fix and yet so difficult to get via a Google search.

[JoeM]

Your welcome. Glad it all worked out!