Search results

Hello again, I've asked before, but I'm not sure Access can do what I want. I know about DateDiff() & it doesn't do it for me. I want a report with each calendar day as a column heading. I want the number in hospital as the value. I only have the start and end date, is there a way of...

Help! I want to produce a query/report that gives me the number of people in hospital each day. Basically I want dates(days)as a column heading. However, I only have the start and end dates of each patient's stay in the table. Is there a way I can reduce this down to numbers per day? Am I...