Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I get 0 when I use calculate sum(field)
Hi JRB-Bldr, Yes I'm running the code within a form text1 (keypress event). My only aim is to get the total qty from my table(invdata) under a specific supplier and display in a textbox. But then when I run the form it gives me a result of 0. I believe miss something in my code. Thanks for the...- rundee
- Post #3
- Forum: Microsoft: FoxPro
-
I get 0 when I use calculate sum(field)
Hi All, I'm new in VFP and I would like to seek help from all experts out there. My question is why I do get 0 when using the following code: SELECT INVDATA CALCULATE SUM(qty_in) TO thisform.totalqty.value for itemcode=thisform.itemno.Value thisform.totalqty.value=thisform.totalqty.value...- rundee
- Thread
- Replies: 7
- Forum: Microsoft: FoxPro
