Attached is an example of counting employees by year given their hire and fire dates. That seems like the same thing as counting students by month given their start and end dates. There are several variations on the theme included. I realize your situation is a little more complicated than this. If you can't figure out how to adapt it, let me know, and I'll look more closely at your specific problem.
testEmployeeGenderHireFire2.qvw 420.5 K
This is very helpful! Thanks!
As you can imagine, it will take a little time to try and implement this. My only concern is that I have something on the order of 80K enrollment records. I think the avg number of days a student is enrolled is close to 200 days. That's like 16million rows if I did a day by day approach like you have done. this is considerably more processesing than the combination of all my other tables.
Maybe I can try to modify it to work on a month by month basis and not day by day.
Either way, thanks for the idea! And some set analysis that works and is related to my topic!