>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 >