>Hello all.
>I have a grid in one of the columns this has severals valors I want put in a text box control the total the value of each cell.
This depends on what you want to sum. If you have, say, 3 numeric columns for which you want to create a fourth column that is the sum of the other three, you can use a SELECT statement like:
SELECT fld1, fld2, fld3, fld1 + fld2 + fld3 AS MySum ...
to get a sum of the columns for each row. This requires creating a cursor from the SELECT and binding the cursor to the grid.
If you want to sum all the rows of a particular column, you can use something like:
CALCULATE SUM(fld1) TO MySum
then display the result in a text box, then update the value on-the-fly if modifications are made.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.