Criteria to only id if not above date

[Ruegen]

I have a table tblSchools with field NewSchoolsID



I require only the schools to show that don't have a date field above date() in a different table

The table tblBookings contains the date field "BookingDate".

I can hide any booking from showing if they are over date() however I want to hide the school if the related school has a date over date()

Is this possible?

[Ruegen]

do I need to rephrase my question?