I would like to know the SQL coding to total records into a new field based on a string in a different field?
I have a contributor table with amounts listed for several contributors. Each contributor has an ID associated with them. Some have made one payment, some have made several.
I would like to total the amounts for each contributor and add that total to another field. If you look at the picture I added, I would like to add the amounts that each contributor ID has given and put the totals in a new field called Total Contributor Gift. I.E. Contributor ID "1" would have a total of $606, Contributor ID "2" would have a total of $1327, etc. Thanks!