date query validation rule in Access

[Guest]

Hi,

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
fields.

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...

Regards

Jeff Boyce
Microsoft Office/Access MVP