All Or None Querys

I am querying my dBase "Reservations" to obtain a range of dates for
rooms in our hotel that are available for a vacationer to reserve...

this is the my present SQL structure (two tables(roomReserve & roomDescribe inner joined)
**********************
SELECT roomReserve.availibility, roomDescribe.numRooms

FROM roomDescribe INNER JOIN roomReserve ON roomDescribe.code = roomReserve.code

WHERE (((roomReserve.availibility) Between 8/20/99 And 8/23/99) AND ((roomDescribe.numRooms)>0));

****************************
The problem is that I do not want any room open dates (roomReserve.Availibility) to come up if any of the days in between the date range have 0 rooms available (in other words no room available on that date) (roomReserve.numRooms)>0

But they do because the query is not correctly written to be an all or none recordset for the date range time peroid…

For example, if I query for the date range of 8/20/99 to 8/23/99 using a criteria that the room must be available (>0), and let's say the date 8/21/99 has 0 rooms available for the King Fireplace room, then the query's results set gives me a list of the other 3 dates (8/20, 8/22, 8/23) for when the King Fireplace room is available...

I don't want anything thing for that date range to come out if any of the dates (within that range 8/20-8/23) have a room status = 0 during that time period...

I need a way to receive an all or none recordset result... with only one query statement…

I do not want to have to query a query… if that's at all possible…

thank you... chris james