Hi Frank,
>is there a way to total a column when using grid controls, if not, recommendations?
I would suggest using your data instead of the control that displays your data.
Put a text box under your grid, in the refresh put:
This.Value = SUM(myTable.myField)
Then just refresh the textbox in your afterrowcolchange or wherever else you see fit.