Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Summing up...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00406972
Message ID:
00407182
Vues:
24
Ulises,
Trey and Ko suggested ways of getting the total you need. Put the code into a form method and call the method from the Grid's AfterInteractiveChange() method. If you're using a parameterized view for the grid you may want to just sum the view information. Be sure you return your record pointer to the correct record or you'll find yourself at the bottom of the grid after each sum!

HTH
Barbara


>Hi all. How can I have a form that displays a grid with, lets say, customers names and account balance, considering that the balance comes from the sum of several records. I want the grid to display the customer's name and the sum of all its balances. Like
>
>Name-----SumOfBalance
>John-----32
>Paul-----27
>Doe------15
>
>Thank you in advance
>Ulises
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform