How Do You Handle Events That Occur On Multiple Dates?

I manage a training database that tracks many different facets of an organization's training needs. One thing I would like to see is something that shows how many people will be in training on any given day. For example, I would like to see a range of dates printed down one column, and in the next column the number of people in training. I'm not sure how to best do this, so I'd appreciate any help or guidance.

To give you all a little background:

- Classes can last several months
- I would like to be able to create a class, including the class name and the date range of the class
- I would then like to be able to attach multiple people to the classes
- I would then like to be able to look at a report like I discussed above, that counts how many people are in any class on any given day

- I currently have a table for all of the people in my organization (keyed by HRID).
- I imagine a table for each class, including the Class Name and Date Range (would I have to do each date as a separate field??).
- The final table would include HRID and Class Name to link the two tables and "put people into a class."

I'm really struggling with how to handle the date range, particularly considering each class may go on for 60+ days. Does anyone know how to do this?

Thank you in advance!