Recent content by Erica Nichols

I tried entering a new field onto the query Stay: (Departure Date)-Arrival Date) This is what the internet info suggested but it gave me an error message saying I may have entered an operand without an operator. So, back to not knowing how to do it

I have found some internet information which suggests creating an additional column and shows how to calculate the stay. This will show me the days for each record. I then need to average the stay per room type so I think I will create a seperate query for each room type. I do not know...

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...