Date and Time

[Loi]

Hi,

I have some problems. Please help me out.
-----------
I have two tables: Borrower and Equipment.(One to many
relationship)
---------------------
Table Borrower has three fields:ID, LastName, FirstName.
Table Equipment has five fields: Equipment, ReserveDate,
ReserveTime,ReturnDate and ReturneTime.
-------
Equipment: Proxima # 2, Proxima # 4 ......
--------
For example:
Kim reserves Proxima # 2,ReserveDate: 9/10/04 ;
ReserveTime: 11:00Am, ReturnDate: 9/11/04; ReturnTime:
5:00Pm. IT means that Kim will use Proxima # 2 from 9/10
at 11:00 am and will return it on 9/11 at 5:00 pm.

I also reserve Proxima # 2 on 9/10/04 form 7:00 Am and
will return it at 5:00 Pm at the same day.

There is a way to stop me when I enter date and time
because Kim reserved the proxima # 2 already.

Thank you very much
Loi

 

[Douglas J. Steele]

Check whether the 2nd Start date is less than the 1st End date AND the 2nd
End date is greater than the 1st Start date.