Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Summing up...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00406972
Message ID:
00407182
Views:
23
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform