Hallo,
I have a table with 4 fields: Organization, Start_Hour, End_Hour, Room. It is about conferences.
My aim is to have a timetable that dislpays the organization name in a crosstable with room and hours.

To reach this:

I made a crosstab query involving Organization, Start_Hour and Room. The organization as displayed data. Then I made the same with Organization, End_Hour and Room. Then I made a union query.
The result is a timetable where I see when a conference starts and when it ends, but I cannot see that between this two points the conference is still going on. I would like to show the organization name in the cells beetween the start and end hour. Do you have a suggestion.

Here the code of the two crosstab queries: (you get the timetable with a third query that makes a UNION of these two)

Query Start_Hour:

TRANSFORM First(tbl_Events.Org) AS FirstOfOrg
SELECT (Format([Start_Hour],"ddddd hh:nn")) AS Expr1
FROM tbl_Events
GROUP BY (Int([Start_Hour]*1440)), (Format([Start_Hour],"ddddd hh:nn"))
PIVOT tbl_Events.Room;

Query End Hour:

TRANSFORM First(tbl_Events.Org) AS FirstOfOrg
SELECT (Format([End_Hour],"ddddd hh:nn")) AS Expr1
FROM tbl_Events
GROUP BY (Int([End_Hour]*1440)), (Format([Start_Hour],"ddddd hh:nn"))
PIVOT tbl_Events.Room;