I am having a problem getting my head around a query. What I want it to do is this. I want to be able to list all available rooms of a certain type between 2 dates and display the result is a dgv so that the user can select the available room(s). The information is held in 2 files:

Calendar
---------
Date
AccountNumber
RoomNo
Status

Rooms
------
RoomNo
RoomType

The 3 fields on the form would be txtArriveDate, txtDepartDate & txtRoomType. I know I can setup a new tableadapter and bind it to the dgv, but it is the query that I am having a problem with.

Any help on this would be appreciated.

Computerman