Hi.
I am doing a database for a hotel (assignment at uni). I have my tables and their relationships, some forms to book a room etc.
Now i need to create report, which would show rooms and guests in these rooms for next week starting from the day when report was opened.
So the tables and connections between them are:

http://img234.imageshack.us/img234/2065/tablesjd3.png

Let say i have opened my report on wednesday, what i need to get is something like that:

Rooms:......Day:...................List of guests in room:
Room1: Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Room2: Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Room3 .....

I created report showing guests booked for next week, grouped by rooms.
But i have no idea how can i get weekdays on my report as well as all rooms, not only booked ones.

Any help would be appreciated.
http://img234.imageshack.us/my.php?image=tablesjd3.png