I did check with the brokprod.dbf and there there are only one record for each ag_id. I found out it only happened to records that contain zero in one of the fields that I am doing the sum. Thanks for all your help.
sherry