hi all,
any idea,help
i need to replace yT.q1= ... with thisform.text11.value

SELECT SUM(IIF(yT.q1=1,1,0)) AS CountOf1, ;
SUM(IIF(yT.q1=2,1,0)) AS CountOf2, ;
SUM(IIF(yT.q1=3,1,0)) AS CountOf3, ;
SUM(IIF(yT.q1=4,1,0)) AS CountOf4, ;
SUM(IIF(yT.q1=5,1,0)) AS CountOf5, ;
SUM(IIF(yT.q1=6,1,0)) AS CountOf6, ;
SUM(IIF(yT.q1=7,1,0)) AS CountOf7 ;
FROM ttable1 yT INTO CURSOR someCursor

thanks.