James,

It will be easier to know what is going on if you post some code and the values you are seeing.

A value such as 0.0012 will show as 0.00 in your field.

>I have a view with a field defined as "0.00 as totVal"
>A scan through another table and hold amounts to variable and do some tallying and basic math.
>when I use REPLACE to put variable value into view filed I loose decimals. My fields in the view shows 0.00 for all amounts when first created. In stepping through code I see the value has decimals but the field value looses decimals after replace.
>I tried set decimal and set fixed but no effect.
>
>Any help Appreciated
>James