Dear Guru
I would like to request for help
I want to calculate the total room rate from another table that store the price
For example,
Room rate -
1/10 is 100,
2/10 is 140
3/10 is 100
4/10 is 150
if i stay from 1/10-3/10, how can i calculate that : expecting answer as 100+140
Thanks
Eric