>>

>>SELECT SUM(rate*SHARE/10000) AS crate WHERE inv_no+salesman = m.ccinv + m.Slsman ;
>>	                FROM comision INTO ARRAY laArr
>>
>>SUM (rate*SHARE/10000) TO cRate WHILE inv_no+salesman = m.ccinv + m.Slsman
>>

>>
>
>Aside from the string matching, there are two potential issues here:
>
>1) WHERE looks at the entire table; WHILE starts at the current record and stops as soon as there's a mismatch.
>
>2) SELECT SUM() ignores Nulls. SUM does not.
>

SUM,AVERAGE,CALCULATE ignores NULLs too.

Fabio

>Tamar