Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select and sum
Message
De
22/11/2004 04:09:14
 
 
À
21/11/2004 11:20:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00963216
Message ID:
00963415
Vues:
6
hi,
thank you very much,it works.

i append new small code to print out the result ,as under
but how i can sum the totals for every customers at my report,.
LOCAL ldStart, ldEnd
ldStart = thisform.pageframe1.page1.text3.value
ldEnd = thisform.pageframe1.page1.text5.value

SELECT datein, inname, billno, SUM( total ) AS bill_total FROM Mstr WHERE ;
  BETWEEN( datein, ldStart, ldEnd ) ;
  GROUP BY inname, billno,datein ;
  ORDER BY inname INTO CURSOR qTmp
SELECT csrBillTotals 
ZAP
APPEND FROM DBF( [qTmp] )
Thisform.pageframe1.page1.grid1.refresh()
REPORT FORM  allcost preview &&
Have you obtained any VFP reference books yet?i haven't any books, i depend at vfp8.help
thanks.
best regards.
m.qasem
thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform