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

See more:

C#

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 tried the below query several times, but I am not getting 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 the 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 achieve this?
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?

Where in the table can I set primary key for column?
Suppose I would like to set primary key in which field I want to set?

Help me?