Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates.
I have a table called conference_room_status which has the fields
Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo
where DateFrom and DateTo (date format) is the starting and ending date of the reservation... and the person may need the conference room only between TimeFrom and TimeTo (time format)...
Any ideas of how to write an sql query to retrieve these records will be greatly appreciated