Thanks a lot! That is exactly what I did. I was hoping to get it done using a clever database structure without having to dabble in scripting. The best I could come up with is to create a whole bunch of rows for each "slot", and linking to a booking table through a query of "available slots"...
I want to set up a simple meeting booking application in Access.
- There are multiple people who can be booked
- The slots have a defined duration of 30 mins
- Each person has a schedule (days of week and times of day)
- A person once booked for a slot can not be booked again
I am totally out...