>thank you vey much, it works
>
>but i need to add monthly new select as below id1 mean month i have id1=1 to 12
>SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=3 AND ID>0 into cursor crs3 readwrite
>replace all Row with recno() in crs3
>
>how i can fix this select if id1=3 and id1=4 to id1=12
> 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
>
>
>
I think we may want to re-write the whole algorithm to do this in one pass. Are you trying to create Year to date columns? So, id2 will get sum of id1 and id2, id3 sum of id1, id2, id3, etc. ?