Andrew & Albert;

Thanks. It'll do.

>Michael,
>
>Check out the TRANSFORM() function
>
>e.g.
>

TRANSFORM(Tquery.Calc_Gross, "@$$ 999,999,999.99")

>Cheers,
>
>Andrew
>
>>I'm doing an SQL statement to build a string field from a number field. I'll be returning the string to a web page, so I'd like to have it appear with commas.
>>
>>I could write a function to convert the number to a string, then concatenate to add the needed commas, but I suspect someone out there has a better way.
>>
>>I'm using:
>>STR(Tquery.Calc_Gross)
>>to show the value without commas
>>
>>Any suggestions?
>>
>>TIA