creating a query? need help badly

[MrT1993]

hi everyone well basically i am creating a laptop booking system
I have a teachers table with relevant teacher information including first name, surname and teacher ID


I have a laptop trolley table consisting of trolley number, number of laptops and base location
i have a laptop table which consists of trolley number, laptop number, operating system and memory
my final table is a booking table which contains teacher ID, booking ID, trolley number, period (only have 5 periods) , date, room and date.

I want to create a query which shows us lessons that the laptops havent been booked for on a certain date.

thank you very much

[MrT1993]

hi there if there is any confusion
i have made forms to do with make a booking however I am stuck on how to
create a query which shows me lessons that the laptops havent been booked for on a certain date.
is there any way to do this, if so how?
thanks very much