Unmatched Query to Prevent Double Booking

[MAC987]

I want to make sure that an item isn't hired out on the same day if the van is not available by using an unmatched query.
Any ideas/tutorial would be grateful!

[pbaldy]

Not sure if this is appropriate:

http://www.baldyweb.com/OverLap.htm

To do what you're describing, you'd create a query that returned all records that WERE hired out, then use the unmatched query wizard to compare that to the table of all items.