Search results

I am trying to create a booking system and now I have 2 tables. One containing caravans that are held on a site and another using the caravan number as a foreign key containing booking information such as dates booked and for which customer. So far I have a query that runs to make sure no...

It kind of does. So I changed my code to: SELECT TblCaravan.[Caravan No] FROM TblCaravan INNER JOIN TblCaravanBooking ON TblCaravan.[Caravan No] = TblCaravanBooking.[Caravan No] WHERE (((TblCaravanBooking.[When Required])>[Forms]![Booking].When_Required And (TblCaravanBooking.[When...

Hi guys, Need help urgently as part of my university assignment. I have a database which is serving to act in place for a holiday park containing caravans. The problem is that within the search criteria I have to find times when caravans are free and bring up a list of available caravans. So...