The columnheader will always change. So it's more of a dynamic columnheader. Depending on the Day of the week. There could be 5 or 3 or 10 teacher who have classes to teacher at different time of the day. The Teacher's name will be the columnheader Basically i'm trying to build a cross-tab query Teaher's names across the top The time is in the left column down and student name Teacher_Name Teacher_Name Teacher_Name Teacher_Name Time Student_Name Student_Name Student_Name Student_Name C1 and R2 = Student_Name C2 and R2 = Student_Name C1 and R3 = Student_Name C1 and R3 = Student_Name and so on The only way i can build a cross-tab query is in crystal report. ;)
