thank you very much, it works
about second part , yes no need


>I think you don't need the second part at all.
>
>Anyway, as I said, apply NVL function.
>
>It should be
>

>replace ty2010 with NVL(AcrsYTD.YTD,0) && - no error message anymore
>

>
>>hi,
>>
>>

>>select T.ID,T.Nam, T.ID1, (select sum(Y2010) as YTD from NewTest T1 WHERE   T1.ID#0  AND T1.Nam = T.Nam and T1.ID1 <= T.ID1 ) as YTD from ;
>>   NewTest T into cursor crsYTD
>>     
>>   update NewTest set ty2010 = NVL(YTD,0) ;
>>         from NewTest inner join crsYTD YTD on NewTest.ID1 = NewTest.ID1 and NewTest.Nam = crsYTD.Nam
>>
>>BROW&&work
>>
>>local lnRecNo
>>lnRecno = 1
>>select NewTest
>>scan 
>>if between(m.lnRecno, 1, reccount('crsYTD'))
>>
>>   goto lnRecno in crsYTD
>>   replace ty2010 with (AcrsYTD.YTD)&&error message
>>   endif
>>   lnRecno = lnRecno + 1
>>ENDSCAN
>>

>>>>HI,
>>>>
>>>>i get the same error,
>>>>i need this code to replace newtest.ty2010 with (AcrsYTD.YTD)
>>>>
>>>>
>>>
>>>Post your current code. Did you apply NVL function where appropriate?