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!