I'm trying to figure out how I can find if a member is eligible with a specfic filtered date range and get a count of each member eligible. Each member has a begin date and an end date. A member can be eligible within the filtered date range if :
1. Their begin date falls within the range
2. Their End Date falls within the date range
3. Their Begin date is prior to the beginning of the date range and End Date is after the end of the date range
Begin and End date are in a seperate "Member" table outside of where the main data table. Houses the eligiblity range, first name, last name ect...