Hi Steve,
As long as your FOR clause is Rushmore optimized it should run at an acceptable speed.
>Hi Ken,
>
> Thanks for the help. But I have one additional question. Is this the only way to calculate the values if the form contain a parent / children relationship? Assuming that the grid is the children and the parent is another table. Would this slow down the processor or the speed if I use the FOR condition inside the SUM command? Eg. Sum orderx.amount FOR orderx.recnum = 999 TO temp
>
>
>>Use either the sum or calculate commands in combination with the underlying field in the table/cursor. You can store the results to a custom property of the form conaining the grid (or other appropriate object). Finally bind your textbox to this property to display the results.
>>
>>>Hi Everyone,
>>>
>>>I have created a grid containing values and I would like to sum up
>>>the values from one particular column into a text field.
>>>
>>>I used the ColumnCount property to get the number of columns display in the grid and some of the rows does not contain any value at all.
>>>
>>>Is there a way to calculate the value in a column for those values that are display in the grid ?
>>>
>>>Any help is appreciated.
>>>
>>>Steve
kenweber
GCom2 Solutions
Microsoft Certified Professional