Something like this, or I missing something:
m.TextBoxValue = thisform.text11.value
m.cFldName = "CountOf"+TRANSFORM(m.TextBoxValue)
SELECT SUM(IIF(yT.q1=m.TextBoxValue,1,0)) AS CountOf1, ;
SUM(IIF(yT.q2=m.TextBoxValue,1,0)) AS CountOf2, ;
SUM(IIF(yT.q3=m.TextBoxValue,1,0)) AS CountOf3, ;
SUM(IIF(yT.q4=m.TextBoxValue,1,0)) AS CountOf4, ;
SUM(IIF(yT.q5=m.TextBoxValue,1,0)) AS CountOf5, ;
SUM(IIF(yT.q6=m.TextBoxValue,1,0)) AS CountOf6, ;
SUM(IIF(yT.q7=m.TextBoxValue,1,0)) AS CountOf7 ;
FROM ttable1 yT;
INTO CURSOR someCursor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
