hi,
thank you for reply,

i have at my table fields as q1,q2,q3....etc

i want to get result ex... for q1 or q2... as
i insert at my thisform.text11.value=q1 or q2...


>>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.
>
>Mohammed,
>I don't uderstan youir question. What you want to do?
>Do you want the SELECTed fields looks like this
>.....
>m.TextBoxValue = thisform.text11.value
>
>
>SUM(IIF(m.TextBoxValue=7,1,0)) AS CountOf7 ;
>....
>
>or you need something else.