I want to create a booking system on Microsoft Access. I have these 4 tables: employees, clients, meeting rooms and appointments. I have an issue with the macro I used. The macro basically checks whether the employee, client or meeting room are being used when booking in order to avoid double bookings. The macro sort of works as it gives me the right message however it proceeds to state that a booking can be made when it shouldn't be able to if the client, employees or meeting rooms are already booked at that specific date and time. I just need help to resolve this. If anyone also knows how to display the appointments in the form of a calendar that would be extremely appreciated.