The value is probably really 15.146. The field is defined to only support 2 decimal places, and it's being rounded. Look at SET DECIMALS and ROUND().
>HI All,
>
>I have this problem when saving data/value.
>the value is numeric 15.14 as a result from a mathematical fomula/calculation (i.g. amount x rate x number of days )
>but when save, it changes into 15.15. When i tried to execute the formula again, it gives the correct result of 15.14
>but everytime I tried to save it, it always changes to 15.15 when save.
>Cant figure out why it changes when being save. There is no other formula link or related to the datafield that could change its value
>except the data entry for that calculation.
>
>any help/idea why this happens would be greatly appreciated
>
>thanks in advance
>
>Sonny
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer