Is there a query for this

Hi All
Front end vb6, back end Access.
Program makes reservations for my library.
4 rooms, length of reservation will be in half hour increments
I need to be sure two events are not booked with overlapping times.
Right now I retrieve a recordset as follows

Date, Room, StartTime, StopTime ( sorted by StartTime)
So a typical recorset with two events scheduled might look like:

12/5/2008 Druker Auditorium 9:00am 10:30am
12/5/2008 Druker Auditorium 1:30pm 4:00pm

Would there be any type of query to be sure another reservation would not
confilct.
e.g. A person would try to book an event from 3:00pm until 6:00pm


Thank you
Harold


.

Relevant Pages

  • Re: Is there a query for this
    ... The logic is that 2 events clash if: ... Use record-level validation to see if there is any other record for which this condition is met ... Date, Room, StartTime, StopTime ... Would there be any type of query to be sure another reservation would not confilct. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is there a query for this
    ... Use record-level validation (the Form_BeforeUpdate event if you were ... Tips for Access users - http://allenbrowne.com/tips.html ... Date, Room, StartTime, StopTime ... Would there be any type of query to be sure another reservation would not ...
    (microsoft.public.access.tablesdbdesign)