>>>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.