as sson as I have fixed the syntax error on the information below I will check the dates but I have changed the criteria slightly because the results I need have to be:
Bookings that are courses, not with exam in the title, not with C as the status ref, and with a specific location, between...