• Sum rows of data in an Access query

    I want to sum rows of data in an access query. Everytime I run the query, it does return any values when there are values there. so I want to "column 1" +"column 2" + "column 3" and then get a returned in result in a new column.

    Jcwsuccess5 pointsBadges:
  • Separate SUM results on a single line

    Can DB2 return separate SUMfunction within one statement. If I have : SELECT BRANCH,SUM(AMOUNT) ,COUNT(*) FROM TableA WHERE BRANCH IN (180002,180092) gives Branch,Amount,Count 180002,+100,3 can I return two SUMs - one for positive values of amount and one for negative amounts so will get :...

    PeterWarren15 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.