>Make a table with two fields one currency and the other numeric with three decimals
>Put this value in the fields 27.0760 in currency and 27.076 in numeric
>Do a transform(CurrencyField,'$,$$9.99') value = 27.07
>Do a transform(NumericField,'$,$$9.99') value = 27.08
>
>Does any body have a work around for this or know why?
>
>
>Shawn Dorion
>E :
Shawn@OurSoftware.com
>
>Web: www.oursoftware.com
The fact that you are transforming a number field from three decimals to two forces a round function on the transformation. With currency fields, the accuracy is preserved, but the value is truncated. ?transform(round(numbs,3),'$,$$9.99')