I have a calculated text field made up concantenated text and various
number fields.
Some of these numbers I need to have show up in the final text as
dollar amounts with two decimal places.
For example, I can concantenate in my calculation as follows:
"Your current hourly pay is $" & (SetPrecision (currentpayfield;2))
and get: Your current pay is $10.5
but I want it to come out as: Your current hourly pay is $10.50
Round and truncate don't solve the problem either.
Any suggestions on how to correctly write this calculation so I can
get the desired result?
Thanks!
Sue