Michale,
Take a look in help
TRANSFORM() Function.
Great function. I love this function and I use it very often, because I not worry what is the type of variable or field.
HTH
>Thank you Vladimir, Do you also think this is caused by the data type of numeric,Could you tell something more detail, I need a confirm solutin to this problem tomorrow ,thank you!
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst