>So does anyone know why MS made the TRANSFORM function respect the SET DECIMALS setting? If I have a field that is N(12,5) and it contains 0.11111 and I transform with:
>
>
>? TRANSFORM(FldName, "999,999.99999")
>
>
>I get 0.11000 if SET DECIMALS is 2, but 0.11111 if SET DECIMALS is 5.
>
>Seems kind of odd to me.
Well, that's how it is.
Re: TRANSFORM() question Thread #
1126152 Message #
1126159
If it's not broken, fix it until it is.
My Blog