I was using round(round(,3,2))
maybe it was it ...
Alessio
>>sorry, I got into confusion :-(
>>I was using the round() function but I got into different results from a software I have to put data into.
>>I think the problem is in my choice to use currency type fieds instead of numeric.
>>I'm going to try to change Datatype and let you know :-)
>>Never mind
>>thanks
>>Alessio
>
>Alessio,
>
>I'm using currency data type and round(, 2). Never had any problem with that