>>>>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')

>>
>>This behavior is related to SET DECIMALS
>>
>>Try: SET DECIMALS TO 5 and see what kind of results you get.
>
>Actually, it's not affected by SET DECIMALS if you specify the TRANSFORM() format.
>If you don't specify it - TRANSFORM(CurrencyField), then it is affected by SET DECIMALS

The InvestLink Tag Team is at it again! <g> Thanks for clearing that up, Trey.