Access2000 tables

I have table “A” that has multiple records with the same account number and different amounts of cash. The sum of these records needs to be updated to table “B” which has one record for the account number and total cash. How can I accomplish this task?