I am working on a booking system.
I have the price for every day in a column, and when the customer do a range search on days to see if rooms are available, I would like to show the price for the chosen time.
Can I sum up the prices for each day in that range, i.e. add the values in column "price" from ,say, day 183 to day 212, if that is choosen?
And can I likewise make an evaluation on the field "available" , that can be "yes" or "no" for that time, so that if all "yes" output is "yes" and if "no"s appear output is "no" - we do not want to see all the yes and nos.?
I have the price for every day in a column, and when the customer do a range search on days to see if rooms are available, I would like to show the price for the chosen time.
Can I sum up the prices for each day in that range, i.e. add the values in column "price" from ,say, day 183 to day 212, if that is choosen?
And can I likewise make an evaluation on the field "available" , that can be "yes" or "no" for that time, so that if all "yes" output is "yes" and if "no"s appear output is "no" - we do not want to see all the yes and nos.?
adding values from fields/ price calculation