Between dates

[Loi]

Hi,

I have the Equipment database which keeps track all
equipment like computer1, computer2, computer3 ...

Example, The table A has 3 fields : EquipmentName,
DateCheckOut and DateCheckIn

EquipmentName Date check out Date check in

computer1 06/17/04 06/20/04
computer2
Computer3

Computer1 has been reserved from 06/17/04 to 06/20/04.(3
days)

It means no one else can use it.

Please show me a way to let another users who want to
check out Computer1 on 06/18/04 to 06/19/04 know that the
Computer1 has been reserved by someone else.


Thank you very much
Loi