Grouping table records within a query 1

[timabc123]

Hi,

I have a table with various headings (employee id, WorkTypeA, WorkTypeB, WorkTypeC, WorkTypeD etc..).

Employee id is not unique.

I need to create a query which will group all of the same employee id together (ie each individual employee) and sum all of the worktypes for that employee id.

Please Help!! Thank you.

 

[TTThio]

Try to paste this code in the query SQL view, I think it will work.

SELECT DISTINCT EmployeeID, Sum(Worktypes) AS Total
FROM TableName
GROUP BY EmployeeID

Tin Tin