I am novice to MS Access. I have created small database. I've got SELECT Query
StudentID Name Last Name CourseName StartTime FinishTime TeacherID RoomID
1 XX YY ZZZ 10:00 11:00 5 RoomA
2 AA BB TTT 09:30 10:30 6 RoomB
I want to display this data as follows
StartTime FinishTime -----------RoomA-------------- RoomB
10:00 ---------- 11:00 ----------- XX YY
-------------------------------------5 , ZZZ
09:30 ---------- 10:30 --------------------------------- AA BB
------------------------------------------------------------6, TTT
I tried to make crosstab query to achieve this but I couldn't.:banghead: Could you please help me on this. Thanks in advance
StudentID Name Last Name CourseName StartTime FinishTime TeacherID RoomID
1 XX YY ZZZ 10:00 11:00 5 RoomA
2 AA BB TTT 09:30 10:30 6 RoomB
I want to display this data as follows
StartTime FinishTime -----------RoomA-------------- RoomB
10:00 ---------- 11:00 ----------- XX YY
-------------------------------------5 , ZZZ
09:30 ---------- 10:30 --------------------------------- AA BB
------------------------------------------------------------6, TTT
I tried to make crosstab query to achieve this but I couldn't.:banghead: Could you please help me on this. Thanks in advance
Last edited: