**count to thisform.text2.value thisform.text2.value =thisform.text3.value +thisform.text4.value +thisform.text5.value +; thisform.text6.value+thisform.text7.value +thisform.text8.value +thisform.text9.value+; thisform.text10.value+thisform.text11.valuethanks
>ex...after count servey_num=1 ,count=150 > servey_num=2 ,count=70 > servey_num=3 ,count=0 >total must be =220 && this is what i need > >i have record have servey_num=0 > >i got total =221 && this is rong >>
>thisform.grid1.VISIBLE=.f. >ldDate=thisform.text1.value >ldDate1=thisform.text12.value >SELECT * FROM mstr into cursor csrmyCursor where BETWEEN(intervdate, ldDate, ldDate1) READWRITE >SELECT csrMyCursor >thisform.grid1.VISIBLE=.T. >With thisform.Grid1 > > .RecordSource = "csrMyCursor" > .Columncount = 8 >ENDWITH > > COUNT TO thisform.text3.value FOR survey_num ==1 and BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text4.value FOR survey_num ==2 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text5.value FOR survey_num==3 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text6.value FOR survey_num==4 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text7.value for survey_num==5 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text8.value FOR survey_num==6 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text9.value FOR survey_num==7 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text10.value FOR survey_num==8 AND BETWEEN(intervdate, ldDate, ldDate1) > COUNT TO thisform.text11.value FOR survey_num==9 AND intervdate>=ldDate AND intervdate<=ldDate1 > count TO thisform.text2.value >>thanks