I am not sure if this will give more information to my problem, but here are a couple rows of my data:
 . ID TRC Quantity Hrs Yr

103187 FEX 8 2007

103187 FEX 8 2007

600508 FEX 5 2007

600508 FEX 6 2007

601729 FEX 8 2007

601729 FEX 8 2007
But when I do Sum for the quantity field, the sums are not always correct. Here is what it shows after I do Sum:
 . ID TRC SumOfQuantity Hrs Yr

103187 FEX 16 2007

600508 FEX 16 2007

601729 FEX 0 2007
Is this easier to understand my problem?
Thank you