Date and time serch

[gayano]

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

[Lupus]

One thing you could do is when the room is booked out have a tick box using a yes/no option to say booked.

That way when you run your query you can select it to give info on everything else.