report writer question

    I am writing a program that helps schedule classes in rooms. The report I need to write is a table that shows what course is in a room at a particular time. It is used to help resolve conflicts - so there could be two classes in a particular room at the same time. Now when I use the crosstab report, only one course is shown - even if there is another course that is in conflict. Another problem is that I would like it to mark when the class is over. So it would look like this

          8:00         9:00       10:00      11:00
        _________________________________________________________
ROOM    | CSE 100 A  |                     | CSE 100 C   |
100     |____________|_____________________|_____________|_______
        | CSE 100 B            |
        |______________________|_________________________________
ROOM    | CSE 100 D  |
200     |____________|___________________________________________

 Do you have any suggestions on how I could do this? Thanks so much in advance for your help.

 Mary Susan

P.S. Thanks to everyone who responded to my earlier question. Received on Mon Sep 06 1993 - 18:39:14 CEST