In a message to ALL, STEPHEN SZYMCZYK said:
SS> I am setting up two tables.  The first table is for donors and the
SS> second is for donations.  I'd like to have a field in the donors db
SS> that contains a  total of all the donations that individual or
SS> company has made.
SS>  
SS> There will be multiple records in donations that will need to be
SS> calced for  the total.  Does anyone know how to do this? 
This is not good design, but if you insist,  you can use a changeto
query to calculate the sum and insert it in the donors.db.  I would
recommend instead that you create a form that links the two tables and
displays the sum of donations from the donations.db along with the name
of the donor from donor.db.
Rich
--- 
---------------