>tmp = "csr" + Sys(2015) >Select id,name,; > SUM(iif(year = 2005, no, $0)) As y2005, ; > SUM(IIF(year = 2006, no, $0)) As y2006, ; > SUM(IIF(year = 2007, no, $0)) As y2007, ; > SUM(IIF(year = 2008, no, $0)) As y2008, ; > SUM(IIF(year = 2009, no, $0)) As y2009, ; > IIF(year = 2010, no, $0) As y2010, ; > SUM(no) as total ; > from table1 ; > GROUP BY 1, 2 ; > into Cursor (m.tmp) >I look so much like Khubaib, that you mixed us :)