>>>>>>>>Hi all,
>>>>>>>>I have a report that in one of it's numeric fields i set its format to 999/999/999. but if my number be 87654 it show as / /87/654 . if i set format as 999,999,999 it show correctly as 87,654 !
>>>>>>>>where i do wrong?
>>>>>>>>Thanks for your help
>>>>>>>
>>>>>>>Use Transform(yourvalue, '@R 999/999/999')
>>>>>>
>>>>>>dear Tore,
>>>>>>when i double click on my field, in window i have two box : 1- expression 2- format
>>>>>>in which box i must use this?
>>>>>>
>>>>>>please test ?Transform(12345, '@R 999/999/999') it is wrong !
>>>>>
>>>>>I don't quite understand.
>>>>>
>>>>>1. Give me an example of a value you have.
>>>>>2. What data type is it?
>>>>>3. Give me an example of how you want to show the value on the report.
>>>>
>>>>My Value is Numeric. i have a numeric column in my report and a sum row too.
>>>>i want to my numbers see such as 454/230/000 in column and 1/000/990/000 in sum for example.but if my field contain any function , i think the SUMMATION dont work and **** will appear instead numbers.
>>>
>>>Use the expression

>>>transform(str(yourValue,9),"@R 999/999/999")

>>>You may have to change 9 to another value inside the str()
>>
>>dear tore
>>excuse me . please test transform(str(yourValue,9),"@R 999/999/999"). it return wrong format . for example transform(str(12345,9),"@R 999/999/999") return / 12/345
>
>I don't understand why you want / as a separator, but I gues you have a good reason. I guess you must write a simple UDF for this, and use DO CASE for the posible number of digits.

yes, i do this but only i have problem when i want to use from this UDF in SUM portion.
when i use in summation field an error was occured(*** )