Search results

Hi Stopher, Many thanks for your prompt reply. An example is as follows: Room number 2 is booked ArrivDate = 04/08/2014 and DurStay is 7 days. When I run the query to find vacant rooms using parameter Start Date 02/08/2014 and End Date 08/08/2014 it says that Room number 2 is vacant during...

Hello Guys, This is my first post. I am a newbie to Access and I am having difficulty with a query I am trying to do. I have a one-to-many relational hotel database set up with 5 tables: Bookings Customers Employees Rooms Room Types What I am trying to do is to run a query where I can check...