SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=1 AND ID>0 into cursor crs1 readwrite replace all Row with recno() in crs1 SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=2 AND ID>0 into cursor crs2 readwrite replace all Row with recno() in crs2 select c2.ID1, c2.Y2010 + c1.Y2010 as Total from crs2 c2 ; inner join crs1 c1 on c2.Row = c1.Row into cursor crsResult nofilter update NewTest set ty2010 = c1.Total ; from NewTest inner join crsResult c1 on NewTest.ID1 = c1.ID1 at crsResult correct brow CLOSE all USE NewTest BROWSE && replace the first value for all mean where id1=2>Hi Mohammed,
>>>>m.tnNumber1=1 >>>> m.tnNumber2=2 >>>> >>>> SELECT ID1 ,Y2010 FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 >>>>id1 y2010 >>>> 1 10.3 >>>> 1 20 >>>> 1 15 >>>> >>>> SELECT ID1 ,Y2010 FROM NEWTEST WHERE ID1=m.tnNumber2 AND ID>0 >>>> >>>>id1 y2010 >>>> 2 12 >>>> 2 11.5 >>>> 2 18 >>>> >>>>i need to sum y2010 where ID1=m.tnNumber1 + y2010 where ID1=m.tnNumber2 and replace at the same table to field ty2010 >>>> >>>>id1 ty2010 >>>>2 22.3 >>>>2 31.5 >>>>2 33 >>>>>>>
>>>SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 into cursor crs1 readwrite >>>replace all Row with recno() in crs1 >>> >>>SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 into cursor crs2 readwrite >>>replace all Row with recno() in crs2 >>> >>>select c2.ID1, c2.Y2010 + c1.Y2010 as Total from crs2 c2 ; >>>inner join crs1 c1 on c2.Row = c1.Row into cursor crsResult nofilter >>> >>>update NewTest set ty2010 = c1.Total ; >>>from NewTest inner join crsResult c1 on NewTest.ID1 = c1.ID1