Updating field based on values in a grid

How do you update the value of a field based on the values of a grid
column.

I.E.

Rec #   Qty
1       100
2       150
3       150
4       200
        ===
        600 <-- this is the value to store

TIA

David Davis
Powder Technology Inc.