Page 1 of 1

Query Help

PostPosted: Thu Sep 29, 2016 1:55 am
by HackinHoodLogicsTm
Hello Professionals...

I have a table that goes as this

ID NAME CONTRIBUTION DATE
1 JOHN $30.00 20/09/1990
2 KANE $25.00 20/09/1995
3 JOHN $15.00 01/10/2000
4 KANE $50.00 05/12/2016

Please is there a way i can query so that i can sum up each persons contribution to display as follows

ID NAME TOTAL CONTRIBUTION
1 JOHN $45.00
2 KANE $$75.00

Please can you guyz help me out here...
Thanks in advance

Re: Query Help

PostPosted: Thu Sep 29, 2016 5:09 am
by stu
MSSQL:
Code: Select all
SELECT
    ContributorID,
    SUM(ContributionAmount) AS TotalContribution
FROM Contributors
GROUP BY ContributorID

Re: Query Help

PostPosted: Thu Sep 29, 2016 8:41 am
by HackinHoodLogicsTm
Thank you Stu...

Will try that and let you know the output.

Re: Query Help

PostPosted: Thu Sep 29, 2016 8:45 am
by HackinHoodLogicsTm
Hi Stu...Please can you explain more into details.

Am stuck with the process

Thanks

Re: Query Help

PostPosted: Thu Sep 29, 2016 1:01 pm
by stu
HackinHoodLogicsTm wrote:Hi Stu...Please can you explain more into details.

Am stuck with the process

Thanks


What rdbms are you using? Access? mysql?

Re: Query Help

PostPosted: Thu Sep 29, 2016 1:36 pm
by HackinHoodLogicsTm
What rdbms are you using? Access? mysql?


Please am using Access

Re: Query Help

PostPosted: Fri Sep 30, 2016 4:08 am
by stu
HackinHoodLogicsTm wrote:
What rdbms are you using? Access? mysql?


Please am using Access


https://support.office.com/en-us/articl ... 5f7484fd0b