Myquery in MSAccess DataBase i tried but not workinghelp me
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.