1 2 3 4 5 6 7 8 9 10
|
SELECT "A" AS q, Sum(IIf([question1]="a",1,0)) AS [question 1], Sum(IIf([question2]="a",1,0)) AS [question 2], Sum(IIf([question3]="a",1,0)) AS [question 3], Sum(IIf([question4]="a",1,0)) AS [question 4], Sum(IIf([question5]="a",1,0)) AS [question 5] FROM Table1 GROUP BY "A"
UNION
SELECT "B" AS q, Sum(IIf([question1]="b",1,0)) AS [question 1], Sum(IIf([question2]="b",1,0)) AS [question 2], Sum(IIf([question3]="b",1,0)) AS [question 3], Sum(IIf([question4]="b",1,0)) AS [question 4], Sum(IIf([question5]="b",1,0)) AS [question 5] FROM Table1 GROUP BY "B"
UNION
SELECT "C" AS q, Sum(IIf([question1]="c",1,0)) AS [question 1], Sum(IIf([question2]="c",1,0)) AS [question 2], Sum(IIf([question3]="c",1,0)) AS [question 3], Sum(IIf([question4]="c",1,0)) AS [question 4], Sum(IIf([question5]="c",1,0)) AS [question 5] FROM Table1 GROUP BY "C"
UNION
SELECT "D" AS q, Sum(IIf([question1]="d",1,0)) AS [question 1], Sum(IIf([question2]="d",1,0)) AS [question 2], Sum(IIf([question3]="d",1,0)) AS [question 3], Sum(IIf([question4]="d",1,0)) AS [question 4], Sum(IIf([question5]="d",1,0)) AS [question 5] FROM Table1 GROUP BY "D"
UNION
SELECT "NC" AS q, Sum(IIf([question1]="nc",1,0)) AS [question 1], Sum(IIf([question2]="nc",1,0)) AS [question 2], Sum(IIf([question3]="nc",1,0)) AS [question 3], Sum(IIf([question4]="nc",1,0)) AS [question 4], Sum(IIf([question5]="nc",1,0)) AS [question 5] FROM Table1 GROUP BY "NC" |
Partager