Hi Nick,
Thanks for the suggestion. I am new to some of this. Where do you insert such code? I tried it in the AfterRowColChange of Grid1 and got an error "Methods or events cannot contain nested procedures or class definitions."

Pardon stupid question. (Would that be PSQ?)

Thanks again,
Sylvia


>Silvia, I usually use the functions like this one for getting the sums:
>
>FUNCTION sum_activity_hours
>LPARAMETER lcEmployeeno
>LOCAL laSum[1]
>store 0 to laSum[1]
>SELECT SUM(activity.hours) FROM activity ;
>WHERE activity.employeeno = lcEmployeeno ;
>INTO array laSum
>RETURN laSum[1]
>ENDFUNC
>
>HTH,
>
>Nick