daniel.dzc
New member
- Local time
- Today, 08:31
- Joined
- Dec 13, 2008
- Messages
- 4
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:
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:Room2: 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.
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:
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
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
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.