Access is dropping values

I have a database that calculates client contributions. One client can have contributions from 2 to 5 different accounts. I put all of those amounts, based on pay date, in one table with an append query. Then I run another query that sums the amounts and puts the results in another table. In between that step, some of the contributions come up missing. Does anyone have any ideas as to why values are missing?