I want to make a query that tells me if a room available for a person to stay. I have a Arrival Date, Checkout Date and a room number field. 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?