Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select and sum
Message
 
 
À
22/06/2005 07:37:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01024603
Message ID:
01025384
Vues:
15
Add 2 more columns to the query
...
SUM(IIF(typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_m, ;
SUM(IIF(typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_a ;
...
After that you can create report variables for tot_m and tot_a in the and with calculation as SUM. You can reference those variables wrapped in Sec2str() in the fields in the summary band.


>I'm sorry to bother you
>I try to do it at my self, I fail
> This code under it works,

<snip>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform