I have a database of 150 volunteers, their starting dates and their ending dates. I want to be able to see how many volunteers I will have on any given day this summer.

I know how to write a query displaying a record count for a specific DateX (how many records return startDate < DateX and endDate > DateX?)

But how can I get this query to iterate and generate a whole list of how many volunteers I will have for EVERY day this summer? Without my having to type each date separately as a parameter.

There is a lot of information on this subject Search for former posts in the forum (for example on "Startdate").

RV