Query for Room Availability

[Deleted member 120010]

I want to make a query in my system which finds out if a room is available for a person to stay in. I want the query to show me a list of rooms that are available between a period of two dates. So if I enter a arrival Date (12/12/12) and then a checkout date (13/12/12) the query then shows me a list of rooms that are free for those dates. How would I go around doing this?

 

[way2bord]

SELECT Room.RoomNumber FROM Room WHERE NOT EXISTS (
SELECT Booking.RoomNumber, Booking.Arrival, Booking.Checkout
FROM Booking
WHERE ((([chkArrival]<=[Checkout])) AND (([chkCheckout]>=[Arrival])) AND Room.RoomNumber = Booking.RoomNumber)
)