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

Question

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.

Answer 1

Hi Lawrence,

 

I am not sure but please check below link may be this can help you.

 

Click Here to Check code

Thanks & Regard

Shambhoo :)