nexxus2k4

you guys are god sends. thank you =)

Alright, here's the problem. I'm using the contact management template. I have 40 records and I'm using one of the list layouts. I have a field in the standard layout labled "total amount invested." This field is a sum of each individuals various investments that they have made over time Example: John Doe Amt1: $75,000 Date: 9/1/09 Amt2: $25,000 Date: 9/2/09 Amt3: $25,000 Date: 9/3/09 Total_Amt_Invested: $125,000 (sum of three previous entries) Susie Q Amt1: $10,000 Date: 9/1/09 Amt2: $20,000 Date: 9/2/09 Amt3: $20,000 Date: 9/3/09 Total_Amt_Invested: $50,000 (sum of three previous entries) Amt1, Amt2, Amt3 and the corresponding date entries are all individual individual fields. The Total_Amt_Invested field is a sum function of those Amt1 etc. fields. Now on my list layout it looks like this John Doe: $125,000 Susie Q: $50,000 Barbara Walters: $90,000 Herbert Hoover: $60,000 Where those amounts are the "Total_Amt_Invested" field for each person Now what I want to do is this: At the bottom of this list I want a field that will sum up the "total_amt_invested" field from each record. So using the above numbers it should put out $325,000 (125k + 50k + 90k + 60k). Essentially adding up the total amount invested by each individual (each individual record) so I get a total amount invested between john, susie, barbara, and hoover. I cannot for the life of me figure out how to do this. Any help would be much appreciated. Thanks in advance. -Michael