HI All,
Im new to access(and im no vb pro too), SOooo Im stuck in a project!! here it goes

I have a two tables
1 Rooms
---------------------(holds room details)
Room no
Room type

2 Reservation
--------------------(Holds reservation)
Room No
Start Date
Start Time
End Date
End Time

from this i like get the reservation detail mostly notreserved details
like: if a room reserved
2007/06/05 12:00 to 2007/06/07 13:00
this room shuold not apear in the serch query results (if i serched for free roms
between 2007/06/05/ any time to 2007/06/06 any time

please bsomebody help