Yes, I added the MembershipTypeID IN (1,2,3,4) in the last updated View you provided.

I think, aside from that one lone record ending in 2017 being a member type 1, I think it's ok.

Humh, I guess that is why J Livingston SQL was asking what is expected come Jan 2016.

I'm thinking that's fine that 2015 data will no longer be available since half into the new season (in this case 2016) is already over.

Come June, that is when they'll want to see 2017-2020 with the option to check on 2016 numbers still.

So I think it's ok for now.

Thanks again for all your help! Your patience with me is greatly appreciated, having stuck through until resolved!