Calculate total giving 2

[abbottboi]

Hi,

I'm working on a database for a charity. i have two tables, one for prospects and one for donations.

Prospects are linked to donations via

donor_id

I know need a report that produces a list of all donors with the total they donated (all donations added up together).

so for each donor_id, sum all donations found in donation_amount that's linked to the same donor_id

I'm sure this is simple but i really need a pointer in the right direction.

Thanks

 

[Golom]

Select P.doner_id, SUM(D.donation_amount) As [Total Donated]

From Prospects P INNER JOIN Donations D
     ON P.doner_id = D.doner_id

Group By P.doner_id

 

[abbottboi]

that looks awesome...

please give me a pointer as to where to add that in my database.

 

[Golom]

Copy it from this thread and paste it into SQL view of a new query in the query designer. Save the query using some meaningful name.

 

[lespaul]

open the SQL view of the query and paste (be sure to correct any table and field names).


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[abbottboi]

Yessssssssssss!

THANKS GUYS!!

 

[Golom]

You're welcome ... but Leslie ain't a guy.

 

[abbottboi]

Sorry.. I'm a newfie (from Newfoundland) so i say guys for everyone..

Thanks Guys and Gals!!

 

[lespaul]

I like to think we're all gender neutral in cyberspace....no offense taken!

Les