The sum for each person (1 Viewer)

ariansman · Feb 1, 2019

We have the following table:

Code:

         EmpName     Payment   
   1       Jack      160
   2       Steve     95
   3       John      47
   4       Jack      25 
   5       kate      12
   6       John      23  
   7       Kate      21

How can we get the sum for each person? A result like the following:

Code:

 EmpName   Payment   
  Jack      185
  Steve     95
  John      70
  Kate      33

I don’t know much about access. I would appreciate for a sql syntax.
Thank you

theDBguy · Feb 1, 2019

Hi. You could try something like:

Code:

SELECT EmpName, Sum(Payment) As TotalPayment FROM TableName GROUP BY EmpName

mike60smart · Feb 1, 2019

Hi

It would make life a lot easier if you had 2 tables

1 for the Employees
1 for the EmployeePayments

Usual setup is a Main form based on tblEmployees and a Subform based on tblEmployeePayments

The sum for each person (1 Viewer)

ariansman

Registered User.

theDBguy

I’m here to help

mike60smart

Registered User.

Similar threads

Users who are viewing this thread