how to write the sub query to convert rows in to columns and

Select * from Table Name;

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

i want the output in ms access database;

for that below how to write sub query and get the below output.

in faculty_code column that GS,NR to be want in the 1/12/2013 date.

for that how to write sub query, convert rows in to columns and put it in to a single column(GS,NR) fro the 1/12/2013 my required output.

Sno Sch_Date Session Course Faculty_Code
1 1/12/2013 1 AFF GS,NR

how can i do.help me.

please reply the answer. i posted question in your site. but some times not updating the answer.

kindly please repay answer for my above question and help me please.