Date range determines appropriate values

Hi all,   I have a report calling a fixed room count per property from my properties table: Each row is dedicated to an individual property, and the room count available on a daily basis spe...