this is my intput
SELECT Tb_Sch_TIme_Table.Sch_Date, Tb_Sch_TIme_Table.Session, Tb_Sch_TIme_Table.Course, Conc("Faculty_Code","Session"[Session],"Tb_Sch_TIme_Table","Sch_Date",[Sch_Date]) AS Faculty_Code
FROM Tb_Sch_TIme_Table
GROUP BY Tb_Sch_TIme_Table.Course, Tb_Sch_TIme_Table.Sch_Date, Tb_Sch_TIme_Table.Session;
when i run the above query;
output as follows in MS Access;
Sch_Date Session Course Faculty_Code<br />
1/12/2013 1 AFF GS,NR<br />
1/13/2013 1 TFC VB
select * from Tb_SCh_TIme_Table;
as follows;
the above output should match which select * from Tb_SCh_TIme_Table;
Sno Sch_Date Session Course Faculty_Code<br />
1 1/12/2013 1 AFF GS<br />
2 1/12/2013 1 AFF NR<br />
3 1/13/2013 1 TFC VB
how can i get the ouput.help me
the above one is my input and output.