I don't have an easy way... but I was thinking about creating a custom grid control with a "controlbreakcol" property, and then adding a subtotal record to the grid everytime the value in the controlbreakcol column changed values... but I never got around to doing it.
Doing what you want, I would say that you should add an additional column, and then in the requery event of the grid, re-populate the column. If you are using views, then you can just make the column based off of a special field created by your select clause.
>Does anyone know an easy way to create a running total (balance) in a grid. Since the user could change row one after entering row four, all rows must be recalc'd. What method should this code go in? Previously in Fox 2.6 I saved the record pointer, summed until reccount and then restored the record pointer.
>
>TIA
>sandi
--Todd Sherman
-Wake Up! Smell the Coffee!