>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.