TRANSFORM Count(tasks.id) AS Countמתוךid
SELECT employee.EmpName
FROM (tasks INNER JOIN employee ON tasks.employee_id = employee.id) INNER JOIN status ON tasks.status_id = status.id
GROUP BY employee.EmpName
PIVOT status.StatusName In ("StatusName","analysis","development","qa","waiting","ready for production","done");
TRANSFORM Count(tasks.id) AS CountOfid
SELECT employee.EmpName
FROM (tasks RIGHT JOIN employee ON tasks.employee_id = employee.id) LEFT JOIN status ON tasks.status_id = status.id
GROUP BY employee.EmpName
PIVOT status.StatusName In ("StatusName","analysis","development","qa","waiting","ready for production","done");
EmpName | StatusName | analysis | development | qa | waiting | ready for production | done |
---|---|---|---|---|---|---|---|
bill | | | 1 | | | | |
Burt | | | | | | | |
Fred | | | | | | | |
Harry | | | | | | | |
john | | 1 | | 1 | | | |
lisa | | 2 | 1 | | | | |
Sorry, typo. That should be Column HeadingSo, for example if you are showing data by month but a recordset might not always contain data for every month, you can add the month names to the Row Heading - Jan, Feb, Mar, etc.
TRANSFORM Count(Tasks.TaskName) AS CountTaskName
SELECT [Employee].FirstName, [Employee].UserName
FROM (Tasks INNER JOIN Employee ON Tasks.Current_ID=[Employee].ID) INNER JOIN Status ON Tasks.Status_ID = Status.id
GROUP BY [Employee].FirstName, [Employee].UserName
PIVOT Status.id In (1,2,3,7,5,4,9,12,13,14,15,16);
You can't do thatso if a person has 6 tasks which 1 is low priority , 3 is mediom priority and 2 in high priority it will be in the same cell
What does that mean? Adding 1 + 2 + 3 doesn't make sense. Are you saying you want to count the number of 1's, 2's, 3's? And are you talking by person?I would like to sum the priorities