>That's what i want but is there a way to keep original set of records in the table.
>>>I need to sum a set of fields by an other field in a table and i'd like to know if my idea is good enough.
>>>(It seemed to be a bit clumsy).
>>>The table is like this
>>>A B C
>>>aa 1 1
>>>bb 2
>>>bb 3
>>>bb 4 9
>>>cc 5 5
>>>dd 6
>>>dd 7
>>>dd 8 21
>>>
>>>So I should sum field "B" by field "A" in the filed "C". I would use 2 do while loops, one of them goes through the table and the other one would sum up the filed B if there are more than two identical ones in field "A". Does it seem ok?
>>
>>I am not sure what exactly you want, but if you want the total for each different text in field "A", a SELECT with a GROUP BY clause will do the job, for example:
>>
>>
>>select a, sum(b) as total_b;
>> from MyTable;
>> group by a;
>> into cursor Temp
>>
UPDATE MyTable;
SET c=X.total_b;
FROM;
(select a;
, sum(b) as total_b;
, count(*) an count_a;
from MyTable;
group by a) X;
WHERE MyTable.a = X.a
