Availability
Posted: Thu May 17, 2012 12:01 pm
We are trying to get a list or table of available apartments after doing an availability check, using the following procedure:
- client calls and requests an apartment for X number of nights, arriving on Date1 and departuring on Date2;
- we insert Date1 and Date2 in the "Availability check" row;
- we can get a table with the availabilty calendar showing all apartments. However we would like to obtain a table only with the "available" apartments. Also, it would be very helpfull to get a row at the top indicating the total number of apartments available for each day.
.........JUNE 1 ...... JUNE 2.......... JUNE 3.......
TOTAL .. 2 ............ 3 ................ 9 ...........
APT1 ... X .............................................
APT2 ................ X .................... X ..........
APT3 ..................X .................. X ...........
What can I modify to make this work in this manner?
- client calls and requests an apartment for X number of nights, arriving on Date1 and departuring on Date2;
- we insert Date1 and Date2 in the "Availability check" row;
- we can get a table with the availabilty calendar showing all apartments. However we would like to obtain a table only with the "available" apartments. Also, it would be very helpfull to get a row at the top indicating the total number of apartments available for each day.
.........JUNE 1 ...... JUNE 2.......... JUNE 3.......
TOTAL .. 2 ............ 3 ................ 9 ...........
APT1 ... X .............................................
APT2 ................ X .................... X ..........
APT3 ..................X .................. X ...........
What can I modify to make this work in this manner?