Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select and sum
Message
De
22/11/2004 04:26:34
 
 
À
22/11/2004 04:09:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00963216
Message ID:
00963417
Vues:
10
>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.

Mohammed,

As to the books, have a look at this http://docs.rinet.ru/GlyadiLisu/ It may help
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform