Thanks Cetin, and yes, it could be better, I was wondering if this is possible with a single query, I'll do the test to see what's the better approach. Thanks again!
>Esparta,
>I think dividing it would be better. Roughly:Select iAgentId, Month(dDate) As Month, Year(dDate) As Year, Sum(yAmount) As YTot ;
FROM cMovs ;
GROUP By 1,2,3 ;
into Cursor crsSums ;
nofilter
Update cAgent ;
SET yMonth = t2.YTot ;
FROM crsSums t2 ;
WHERE t2.iAgentId = cAgent.iid ;
AND cAgent.nMonth = 1 And cAgent.nYear=2005 ;
And t2.Month = cAgent.nMonth ;
AND t2.Year = cAgent.nYear
