nested AND loop query

[aaaagc]

I have this Table :

ID Course Det1 Det2 Det3
St_1 Curse1 1 2 3
St_1 Curse2 1 2 3
St_1 Curse3 1 2 3
St_2 Curse1 1 2 3
St_2 Curse2 1 2 3
St_2 Curse3 1 2 3
St_3 Curse1 1 2 3
St_3 Curse2 1 2 3
St_3 Curse3 1 2 3
St_4 Curse1 1 2 3
St_4 Curse2 1 2 3
St_4 Curse3 1 2 3
St_5 Curse1 1 2 3
St_5 Curse2 1 2 3
St_5 Curse3 1 2 3


AND I Need This Report By using query only :

Curse1 Curse2
Curse3
Det1 Det2 Det3 Det1 Det2 Det3 Det1
Det2 Det3
St_1 1 2 3 1 2 3 1
2 3
St_2 1 2 3 1 2 3 1
2 3
St_3 1 2 3 1 2 3 1
2 3
St_4 1 2 3 1 2 3 1
2 3
St_5 1 2 3 1 2 3 1
2 3


OR this Report :
Curse1 Curse2 Curse3
St_1 1 2 3 1 2 3 1 2 3
St_2 1 2 3 1 2 3 1 2 3
St_3 1 2 3 1 2 3 1 2 3
St_4 1 2 3 1 2 3 1 2 3
St_5 1 2 3 1 2 3 1 2 3

 

[KARL DEWEY]

Try this --
TRANSFORM First([Det1] & " " & [Det2] & " " & [Det3]) AS Expr1
SELECT aaaagc.ID
FROM aaaagc
GROUP BY aaaagc.ID
PIVOT aaaagc.Course;

 

[aaaagc]

Thanks for this god query , but i need it with split fields if possible