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?