concatation query is not working in msaccess i tried but not the correct output

Revision 1
my below typed in the Ms Access DataBase


Select * from Tb_Sch_TIme_Table;

Sno Sch_Date Session Course Faculty_Code
1 12/01/2013 1 AFF GS
2 12/01/2013 1 AFF NR
3 13/01/2013 1 TFC VB

i try the below query several times but not get the correct output.

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") AS Faculty_Code
FROM Tb_Sch_TIme_Table
GROUP BY Tb_Sch_TIme_Table.Course, [Sch_Date], [Session];

output as follows using the above query;

Sch_Date Session Course Faculty_Code
12/01/2013 1 AFF GS, NR, VB
13/01/2013 1 TFC GS, NR, VB

the above output is not correct.

i need output as follows (compare with Select * from Tb_Sch_TIme_Table)

Sch_Date Session Course Faculty_Code
12/01/2013 1 AFF GS, NR
13/01/2013 1 TFC VB

how can i do.i tried several times but my output is not matching with select * from Tb_Sch_TIme_Table.

from my above query what is the mistake.

whether in the table can i set primary key for column.suppose i want to set primary key in which field i want to set help me.