The fields that matter are Status and Date, I am trying to search in this manner:
status must equal unique0 and dates must be between two submitted query dates.

However I gave it some thought and I have duplicated the date field, (different field names "Checkin" "Checkout" but the with the same data)
So now I search for status, and then perform the range search in the two date fields.
It works but a bit messy.
The result gives the vacant rooms that fall into the period between the two submitted dates. My front end script takes care of the time details.

I now have to work on how to see if a room is booked for part of the time between the two given dates.

Any sugestions?

rgs Peter