date query validation rule in Access




I am trying to create an database whereby I can track all departmental loans
of laptops and projectors etc.

I want to be able to create a way of getting Access to check if a particular
peice of equipment is already booked out by querying the dates of a previous
record when somebody enters a new record.

I have ten peices of equipment, all in their own table, another table for
details such as name telephone number etc of the loanee including a combo box
based of the peices of equipment and two fields called 'Date Loaned Out'
field and a 'Planned Return Date'. I do not know how to setup the dates

Please can somebody help me to to create a validation rule that looks up and
denies new bookings/records to be created between the 'Date Loaned Out' field
and the 'Planned Return Date' for a particular peice of equipment.

This is my best guess at how to do it, but if it is something else like
table relationships that will solve my problem please let me know how.

Thanking you all in anticipation.

Jeff Boyce

?You are using separate tables for each piece of equipment? That might be
the approach to use in a spreadsheet, but you won't get the best use of
Access' features and functions if you treat it like a spreadsheet.

Unless I've misunderstood your design, you really need to take the time to
normalize your data before trying anything else. If you don't have the data
structure down, everything else is much harder...


Jeff Boyce
Microsoft Office/Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Left Join issues 1
Table Validation rule 2
Filter By Date 6
Validation Rule Question 9
Validation Rule 2
Another most-recent date query 0
Date Validation Problom! 1
Table Validation Rule for Date 1