Counting number of records for each day 1

[sbbrown9924]

I have a database where I am collecting statistics on the number of patients that visited an emergency room. I need to be able to report the highest number of patients that visited in one day during the time reporting interval. I have a simple query that asks for all records in the visitor log database between two dates. Any ideas how to set this up?

 

[dilettante]

Assuming your query properly groups the records by date and fetches aggregate values (Count(), etc.) it's just a question of displaying/reporting the results, isn't it?

If I were doing this I'd probably write it as an HTA to provide a decent UI for selecting the date range, then populate an Excel worksheet in a new workbook with the counts by day, and finally add an Excel chart based on the worksheet.

Most of that has been described here in other threads, perhaps a few FAQs.

 

[sbbrown9924]

cool - I have a hard time planning out these things. Thanks.