Total by Day between 2 Dates (1 Viewer)

[Joey_S]

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 making sense?
Sorry if this has been answered somewhere else - I did look, honest!

 

[Jack Cowley]

Search Help for the DateDiff() function.

 

[Joey_S]

Thank u kindly, Jack, but doesn't DateDiff() just give you the number of days/weeks/years etc between two dates? I want number of people for each day between two dates.
EG a patient is admitted 1st March and discharged 15th March. How do I get from that a report with the date: 1st, 2nd, 3rd etc as column headings, showing 1 patient for each day between 1st and 15th March.