-
Help finding open time interval amoung data with only occupied times.
I'm having a hard time figuring out this problem in a good way.
The table I must work with is a MS Access "Appointment" table that only holds existing customer appointments. It does not hold open time slots just the ones that are taken/booked. Now I need to have a query or several queries that finds the "next available opening" from some start time onwards.
The fields I'm using from the table are [Occur Date], [Time] and [Length] which are the date, time and length of the appointment.
Say "aStart" is the variable that holds a appointment request's earliest possible booking date and time.
What is the best way to set this up?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|