Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grand total from repeating values in fields
Message
De
15/05/2001 16:08:49
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Grand total from repeating values in fields
Divers
Thread ID:
00507483
Message ID:
00507483
Vues:
58
I create a cursor which combines repeating information, i.e. an account no, requitsion number, total for account form
a table and equivalent total as a calucation, total for requitions, and line item valuses for a requistion. Data is pulled
together from several tables and is checking for inconsitancies in between various totals. so I could have

acct # , req # , total from table , calculated total, etc
a 1 11 10
a 2 11 10
a 3 11 10
b 5 22 20
b 5 22 20

that is totals for acct # a are 11 and 10 and differences is 1, and for account b they are 22 and 20, and difference is 2.
The grand total should be 33 and 30 and difference is 3. How can I do this (I would like results printed in table summary)?
My attemps either give me valuses for last record or sum of all values, i..e. 22, 20, 2 or 77. 70, 7.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform