JithuAccess
Member
- Local time
- Today, 06:39
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
In my table I have fields Employee ID, category and Amount. I have more than 5000 records. In the category field, I have values like "Salary", "Commission", and "Bonus" Is it possible to find the sum of these categories by Employee ID. Currently I am doing this in Excel manually like below:
And here I am manually adding the values of "Salary, "commission" and "Bonus".
It will be highly appreciate and save huge amount of time if I can use a query to find the sum
Thanks in Advance
In my table I have fields Employee ID, category and Amount. I have more than 5000 records. In the category field, I have values like "Salary", "Commission", and "Bonus" Is it possible to find the sum of these categories by Employee ID. Currently I am doing this in Excel manually like below:
And here I am manually adding the values of "Salary, "commission" and "Bonus".
It will be highly appreciate and save huge amount of time if I can use a query to find the sum
Thanks in Advance