I need help with a query i'm having trouble with.
Theres 14 rooms in the Rooms table. When som1 cheks in a record is made in a BillTable. There is more than 1 entry per room in this table, as all records of ppl staying are kept here. This bill table has a checkbox, which is ticked when a guest checks out.
Because the tables are linked, i only get the records of those on both tables, and not of all the rooms. How can i make it so all the records appear.
I need a list of all vacant rooms.
I've got a query which looks for all the un-checked boxes (i.e. all the currently vacated rooms) and returns the room numbers. Is there a way i can use this query to get a list of all the vacant rooms (i.e. those not on this list).
Mite make it easier to understand if u look at the attached pic.
Greatly appriciate any help. Thanks in advance.
Theres 14 rooms in the Rooms table. When som1 cheks in a record is made in a BillTable. There is more than 1 entry per room in this table, as all records of ppl staying are kept here. This bill table has a checkbox, which is ticked when a guest checks out.
Because the tables are linked, i only get the records of those on both tables, and not of all the rooms. How can i make it so all the records appear.
I need a list of all vacant rooms.
I've got a query which looks for all the un-checked boxes (i.e. all the currently vacated rooms) and returns the room numbers. Is there a way i can use this query to get a list of all the vacant rooms (i.e. those not on this list).
Mite make it easier to understand if u look at the attached pic.
Greatly appriciate any help. Thanks in advance.
