Hi everybody,
I hope you can help me tackle this little pb.
OK, I need to create an access database aimed at booking salesmen trips to different cities (NY, Dalllas, Washington, Miami). Basically, I'm using 4 fields: Saleman, Location, Star Date and End Date. Now, I need to create a validation rule that will prevent a salesman to register for a date and location that has already been assigned.
Upon insertion of a new record, I will need to compare the date range (let's say I'm inserting John Smith, New-York, start: 04/01/2006 end: 04/07/2006) against other previously entered date range for the same location (Lets' say John Doe, New York, start 04/08/2006, end 04/20/2006) so that I don't have two guys booked for the same location within the same period.
The logic/validation rule should check other location fields date ranges and prevent a new record to be created if the dates are overlapping.
Any help /ideas would be greatly appreciated.
Thanks in advance for your time :cheesy:
Jean-Yves