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