Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count exactly
Message
From
29/05/2006 08:27:07
 
 
To
29/05/2006 08:19:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01125645
Message ID:
01125647
Views:
19
i think count to thisform.text2.value it must be as..
**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.value 
thanks
>hi all,
>i try via this code under to count records for every servey_num,
>
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform