Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sum of Grid Column
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00111764
Message ID:
00111799
Views:
12
If the recordsource of the child is a table, then a SQL-Select would work. Otherwise, the old Calculate Sum To command needs to be used.



>>I have a grid which the user can add records to a child table. Does VFP have a method for calculations on columns and/or rows. I would like to sum a numeric column without having to access the child table. Any help is greatly appreciated.
>>
>
>No method so far. I would suggest a custom method be created and do the calculation by SELECT-SQL to make it independent with the source table, thus, no direct access on the data and so record pointer will not change. The Method is actually a wish list of mine on the upcoming version releases because PB Data Window is supporting that feature.
Previous
Reply
Map
View

Click here to load this message in the networking platform