Script to give the sum of multiple fields
I need to track multiple donations given by an individual. Presently I have Sum ( donation 1 ) and now need to include donation 2 thru 6 fields.
How do I go about this?
the table approach sounds great just not sure how to approach it. If I have a contacts table which has the donation 1, donation 2 . . . thru 6 then I create a table labeled "donations" and what do I put in it? (duplicate all of the donation 1 thru 6)? And then connect the respective fields? Or do I create the new table with these fields in it and delete them from the original table. You can see I do not know how to approach this and if you don't mind outlining the procedure so that I can recreate it that would be great.
Yes you will want to have a related donations table that can be joined by ContactID.
Each new donation will be its own seperate record.
So, if you have a contact Bob that has 3 donations, there will be one record in Bob that stores Bob's information and then 3 records in donations with Bob's ID. So let's say Bob is ID 3, then it would be something like:
You would not store any donation amt in the contacts table.
Retrieving data ...