more working on the profile project; using choir profiles as my learning tool. im using the below document, from Shelby-Online-Support, as my guide.

Notes -
1)all the profiles have a Start Date of 01.05.2006
2)the ppl still in choir have no End Date
3)the End Dates of ppl that quit choir vary btwn 03.01.2006 - 06.30.2006

My test results:
1)
Begin from Date - 01.01.2006
Begin to -
End from -
End to Date - 08.24.2006
Results - 16 ppl - Start Date [joined] after 01.01.2006 & End Date [quit] before 08.24.2006

2)
Begin from Date - 01.01.2006
Begin to -
End from Date - 08.24.2006
End to -
Results - 53 ppl - Start Date [joined] after 01.01.2006 & End Date [quit] after 08.24.2006

3)
Begin from -
Begin to Date - 01.01.2006
End from Date - 08.24.2006
End to -
Results - 0 ppl - Start Date [joined] before 01.01.2006 & End Date [quit] after 08.24.2006

4)
Begin from -
Begin to Date - 01.01.2006
End from -
End to Date - 08.24.2006
results were 0 ppl - Start Date [joined] before 01.01.2006 & End Date [quit] before 08.24.2006

5)
Begin from Date - 01.01.2006
Begin to Date - 08.24.2006
End from -
End to -
Results - 69 ppl - Start Date [joined] after 01.01.2006 & Start Date [quit] after 08.24.2006

6) Currently in…
Begin from -
Begin to Date - 08.24.2006
End from Date - 08.24.2006
End to -
Results - 53 ppl - Start Date [joined] before 08.24.2006 & End Date [quit] after 08.24.2006

7)
Begin from -
Begin to -
End fom Date - 01.01.2006
End to Date - 06.30.2006
Results - 16 ppl - End Date [quit] after 01.01.2006 & End Date [quit] before 06.30.2006

8)
Begin from -
Begin to Date - 01.05.2006
End from Date - 08.24.2006
End to -
Results - 53 ppl - Start Date [joined] before 01.05.2006 & End Date [quit] after 08.24.2006

9)
Begin from Date - 01.01.2006
Begin to -
End from -
End to -
Results - 69 ppl - Start Date [joined] after 01.01.2006

Conclusions -
1)The only method I found to find everybody that was in choir btwn a date in the past and current is #9.
My applicaton of this will be our Workers Appreciation Banquet. I will need to find everyone that has voluntereed in all the ministries btwn 2 years prior and current.
2)Be mindful when you are processing these reports of the specific Start & End Dates of the profiles you assigned. For Example, test #5 shows, those ppl w/ Start Dates btwn 01.01.2006 & 08.24.2006, only ppl that have joined choir btwn 01.01 & 08.24. A Test #5 scenario could give you different results than #9.