I have a query set up to try to find rooms that are not booked - I have just added into the bookings a field (booked) which is yes/no in the hope that I can list all the free rooms - the query asks for the arrival date and the departure date but no luck on the rooms.
pic of tables - this is for a school project
Been there done that
You need to right a query and a function that looks at the in date outdated and today date if the today date between in date and out date then that unit is booked
As I have written my own booking program for my parents about 5 years If you want help buzzy me
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
thanks for your rely - just tried it not sure if fully correct (my end) - comes up with error - have screenshot of the code in place and have changed my fields to Adate and Ldate and added todate into the bookings table. when i run the query comes up with error -
would be grateful if you could have a quick look over.