C
Christopher Shanahan
The problem:
I have table of dates with associated milestone codes. One of the codes
refers to admissions and another to discharges.
By linking the table with itself, filtering on the these codes, and
performing a datediff() function in a select query on the dates, I can
calculate things like average, max, min, s.d. on the length of stay etc.
Now I would like to create a running daily census graph by date to embed
into a report. My guess is I will need to use an Array to:
1. handle all the calculations to get the instantaneous census (people
admitted but not discharge - based on the date) and
2. then temporarily store this data, and then,
3. associate these calculated values with the dates in order to graph
them.
Additionally, while it may be possible for a clever set of queries to pull
this off, it would be efferent enough for a report.
So 2 questions:
1. Am I barking up the correct tree?
2. If so does any have any ideas how to build such an array function in VBA?
Thanks
Christopher
I have table of dates with associated milestone codes. One of the codes
refers to admissions and another to discharges.
By linking the table with itself, filtering on the these codes, and
performing a datediff() function in a select query on the dates, I can
calculate things like average, max, min, s.d. on the length of stay etc.
Now I would like to create a running daily census graph by date to embed
into a report. My guess is I will need to use an Array to:
1. handle all the calculations to get the instantaneous census (people
admitted but not discharge - based on the date) and
2. then temporarily store this data, and then,
3. associate these calculated values with the dates in order to graph
them.
Additionally, while it may be possible for a clever set of queries to pull
this off, it would be efferent enough for a report.
So 2 questions:
1. Am I barking up the correct tree?
2. If so does any have any ideas how to build such an array function in VBA?
Thanks
Christopher