My house rental reservation program needs a calculation or script to determine whether a query for a date range at a rental property is already booked. The reservation table, indicates renter ID, arrival and depart dates as seperate fields, and at which property from a value list.
The missing step is to block a new reservation that conflicts with an existing one. I'm thinking a script, a conditional or a validated calculation would do the trick but do not know how to construct it. A dialog indicating ' dates are not available' would be ideal. Any ideas?