In Ms access database i required the above output

See more:

C#

Tb_Sch_Time_Table records as follows in MS access database.


Faculty_Code Sch_Date Session


CAN 4/15/2013 3
VB 4/15/2013 4
AKR 4/16/2013 3
CAN 4/16/2013 4
VB 4/17/2013 3
UNNI 4/17/2013 4
CAN 4/18/2013 3
UNNI 4/18/2013 4
VRV 4/19/2013 3
SAN 4/19/2013 4


from using the above table records i want the output as follows in ms access database


Sch_Date session3 Session4

4/15/2013 CAN VB
4/16/2013 AKR CAN
4/17/2013 VB UNNI
4/18/2013 CAN UNNI
4/19/2013 VRV SAN

for getting above output how can i do in MS Access Database.

Regards,
Narasiman P.