>When I set the RowSource Property in a ListBox to a Select-SQL and the type of the selected field is monetary, is selected with 4 decimals.
>I need to show this field with 2 decimals into a ListBox.
>
>Example:
>
>Field AMOUNT of Invoice Table is Monetary.
>
>List.RowSource = 'Select AMOUNT From Invoice Into Cursor curAmount'
>List.RowSourceType = 3 && Select-SQL
>
>Result:
>1000.0000
>1256.0000
>3240.5600
>...
>
>I Need the follow result:
>1000.00
>1256.00
>3240.56
>
>Please, send me any suggestion. Thanks
Simple suggestion:
select str(field2,10,2) as newfield from table1
Edward Pikman
Independent Consultant