sg, my apologies for the confusion.

This will operate based on fiscal year 07-01-2014 to 06-30-2015. I am in need of a count of consecutive fiscal years if the person has participation in this fiscal year and has previous participation in preceding fiscal years up until a lapse or the beginning of their participation. The query I included was for calendar year as my thought was to start basic and expand as I went along since I have never had recourse to do a count like this before.