Myquery in MSAccess DataBase i tried but not workinghelp me

Question

My query as follows in ms access data base. Table name is Tb_SCh_TIme_Table. in the below query i am using only one table.the table name is Tb_SCh_TIme_Table. 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,Tb_SCh_TIme_Table.Faculty_Code PIVOT Tb_SCh_TIme_Table.Session output as follows; Sch_Date Course 1 2 3 12/01/2013 AFF GS 12/01/2013 AFF NR 13/01/2013 TFC GS 13/01/2013 TFC VB VB But i want the final output as follows in MS Access Data base only. from above i am using the query,using the above query how to get the below output.how can i do.you use only my above query to get my final output as below. Sch_Date Course 1 2 3 12/01/2013 AFF GS,NR 13/01/2013 TFC GS 13/01/2013 TFC VB VB please help me. in ms access data base. Thanks & Regards, Rao.