Erica Nichols
New member
- Local time
- Today, 11:20
- Joined
- Mar 23, 2012
- Messages
- 3
Hello
I have a small table for a hotel with 30 rooms.....3 room types. I have to find out:
1. The average length of stay per room type
2. The average # of visitors per room type
3. The base income per room length of visit x daily rate) during a specified period of time (a single month)
I have the following fields:
First Name
Last Name
Room Name
Room Type
Arrival Date
Departure Date
# Guests
Daily Rate
I have been able to do a query including the room type, arrival and departure dates.
I have been doing a bunch of online learning for access but it is not helping. Maybe I am taking the wrong online courses. Can anyone help me to understand how to make calculations and where they are placed in a query.

Thank you
Erica
I have a small table for a hotel with 30 rooms.....3 room types. I have to find out:
1. The average length of stay per room type
2. The average # of visitors per room type
3. The base income per room length of visit x daily rate) during a specified period of time (a single month)
I have the following fields:
First Name
Last Name
Room Name
Room Type
Arrival Date
Departure Date
# Guests
Daily Rate
I have been able to do a query including the room type, arrival and departure dates.
I have been doing a bunch of online learning for access but it is not helping. Maybe I am taking the wrong online courses. Can anyone help me to understand how to make calculations and where they are placed in a query.

Thank you
Erica