Thanks all for your help with this one. Reading through all your suggestions it looks like using a tally is what'll work for us. The dataset is only about 2,800...

That's exactlly what I'm after. Thanks very much.

The difference is because our EndDates are inclusive. I.e. someone that was a member between 5 and 10 has been active for 6...