Date Query

[Sue]

I have created a database to keep track of our equipment
(laptops and tablets)that are "checked out" to be used to
train other departments in our organization. I have two
date fields - Check Out Date and Return Date. Is there a
way to set up a query so that if a person checks out a
laptop on June 17th and will return it on June 20th, no
one else will be able to check it out between the 17th and
the 20th? Thanks so much for your help!

 

[John Vinson]

I have created a database to keep track of our equipment
(laptops and tablets)that are "checked out" to be used to
train other departments in our organization. I have two
date fields - Check Out Date and Return Date. Is there a
way to set up a query so that if a person checks out a
laptop on June 17th and will return it on June 20th, no
one else will be able to check it out between the 17th and
the 20th? Thanks so much for your help!

In addition to Tyler's suggestion, you can base the check-out list on
a Query with a criterion of

Date()

on the [CHeck Out Date] field, and

< Date()

on the [Return Date].

Note that the item might not actually be returned on time - might you
want three datefields, the CheckoutDate, DueDate, and CheckInDate?
With this structure you could use a criterion of

IS NOT NULL

on the CheckInDate.