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?