Daily Census from Admit Date / Discharge Date

I have a table with individual customers that are housed in one of our facilities.  Updates to these records occur every hour.  I can create a Summary Table where Admit Date is less than or equal to t...