How do I get the total of a flexgrid column. I'm trying to use:
Public Function GetTotal()
Dim Total
i = 0 to flexGrid.Rows - 1
Total = Total + flexGrid.TextMatrix(i, 0)
Next
txtTotal = Total
End Function
The above just concatonates the numbers instead of adding them together. Like:
1
1 =11
Instead of
1
1 = 2
I've tried using CStr, CDbl, CSng, but none of them work either. Rob
Just my $.02.
Public Function GetTotal()
Dim Total
i = 0 to flexGrid.Rows - 1
Total = Total + flexGrid.TextMatrix(i, 0)
Next
txtTotal = Total
End Function
The above just concatonates the numbers instead of adding them together. Like:
1
1 =11
Instead of
1
1 = 2
I've tried using CStr, CDbl, CSng, but none of them work either. Rob
Just my $.02.