Source language: Translate to:

Query Help

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Query Help

Postby HackinHoodLogicsTm » Thu Sep 29, 2016 1:55 am

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
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Query Help

Postby stu » Thu Sep 29, 2016 5:09 am

MSSQL:
Code: Select all
SELECT
    ContributorID,
    SUM(ContributionAmount) AS TotalContribution
FROM Contributors
GROUP BY ContributorID
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am

Re: Query Help

Postby HackinHoodLogicsTm » Thu Sep 29, 2016 8:41 am

Thank you Stu...

Will try that and let you know the output.
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Query Help

Postby HackinHoodLogicsTm » Thu Sep 29, 2016 8:45 am

Hi Stu...Please can you explain more into details.

Am stuck with the process

Thanks
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Query Help

Postby stu » Thu Sep 29, 2016 1:01 pm

HackinHoodLogicsTm wrote:Hi Stu...Please can you explain more into details.

Am stuck with the process

Thanks


What rdbms are you using? Access? mysql?
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am

Re: Query Help

Postby HackinHoodLogicsTm » Thu Sep 29, 2016 1:36 pm

What rdbms are you using? Access? mysql?


Please am using Access
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Query Help

Postby stu » Fri Sep 30, 2016 4:08 am

HackinHoodLogicsTm wrote:
What rdbms are you using? Access? mysql?


Please am using Access


https://support.office.com/en-us/articl ... 5f7484fd0b
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: Bing [Bot] and 1 guest