Formating numers to add comas in a char field

[MikeL91]

My sorting software will not allow numeric fields, so I have to convert all numeric fields to char. But when I print my output, I need to have 1000 seperator comas in the numbers. Id there a easy function to add the comas to a number?

 

[rgbean]

Mike,
If mytable.myfield is defined as Character, then try something like:
?Transform(val(mytable.myfield), "999,999,999.99&quot

Rick

 

[MikeL91]

Thanks Rick,
you rock!