In MS Access database as follows:
Date Session Course Faculty_Code
25/01/2013 1 AFF GS
25/01/2013 1 AFF VB
I would like the output as follows:
Date Session Course Faculty_Code
25/01/2013 1 AFF GS,VB
When I tried your query output shows as follows:
I tried with this query:
TRANSFORM First(Tb_SCh_TIme_Table.Faculty_Code) AS a
SELECT Tb_SCh_TIme_Table.Sch_Date, Tb_SCh_TIme_Table.Course
FROM Tb_SCh_TIme_Table
GROUP BY Tb_SCh_TIme_Table.Sch_Date, Tb_SCh_TIme_Table.Course
PIVOT Tb_SCh_TIme_Table.Session;
When I tried your query output shows as follows;
Date Session Course Faculty_Code
25/01/2013 1 AFF GS
In the above output not showing the Two faculty name only shows the GS
Faculty_Code
. I would like the VB
Faculty_Code
also.
I need the final output as follows:
Date Session Course Faculty_Code
25/01/2013 1 AFF GS,VB.
For the same date, session and course, different faculty takes class I need to mention both Faculty_Code also.
How can I write the query to get the final output as I mentioned above.
Please help me. How can I do it?
Thanks.