I need to create a query that I will use to generate a report that shows how many clients were active in a given time frame. My client table is provided below:
tblClients
ClientID (PK)
FirstName
LastName
ProgramStartDate
ProgramEndDate
If I want to determine how many clients were active between October of 2016 and October of 2017, how would I create a query that I can use to generate this report? I know that I will need to use the Program Start Date and Program End Date in creating this query, but I don't exactly know how to go about doing so.