format field...

[bigdad]

hi everybody. I need that some body tell me if know hao can I do for changue the format of a field. to be more especific: I´ve this number: 123456789,12 well my question is how can I do for changue this number to: 123.456.789,12.

I need this because I´m working righ now with a report of a departament store system and the cost of the products need it this format: 123.456.789,12 $

If some body can help me thank´s a lot

Bigdad

 

[rgbean]

BigDad,
It's not clear whether you want to store the data this way, or whether you just want to display it this way on a form or report.

Rick

 

[bigdad]

in both way!! I explend to you: In a textbox I need write two thousand dollars with 25 cts: 200000,25 right?? well I need that the textbox format:200.000,25, the same format in my field table and in my report too. if I need put one million: 1.000.000, with the "point"

 

[DSummZZZ]

Try this:
SET POINT TO ","
SET SEPARATOR TO '.'
?123456.78 picture '999,999,999.99'
?TRANSFORM(123456.78, '999,999,999.99')

For your text box on the form an in the report, you can use '999,999,999.99' for the format.

To update the field, you can use:
REPLACE MyTable.MyField WITH ;
TRANSFORM(MyTable.MyField , '999,999,999.99')

However, as long as they are being displayed properly on the form and report, you really don't need to add the extra characters to the table.
Dave S.