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

Reply via email to