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