>Thank you for your reply. May be what I want is how to turn the field into a string and the out come will be 99,999.99. I remembered there is a command format()???.
>sherry

It's hard to help if you aren't sure what you want. :)
Anyway try

TRANSFORM(myfield, "99,999.99")