Count Consecutive Years 1

[IbeKaba]

I'm using Crystal 9, pulling from a SQL database, using ODBC connection.

I'm pulling records from two tables. One table has general info, and the other has gift info. The two tables are linked by ID. Since there are many corresponding gift records for a donors, I have my report grouped by ID. Hence for each ID I have listed all the years that donor has made a gift in.
Example:

ID GftYear
111
2006
2005
2004
2001
222
2006
2004
2003
2001
333
2005
2004
2002

Here is the deal: I would like to know, for example, how many people have given three consecutive years in a row. (In the above example that would be only ID 111). Is this possible in Crystal? If so, how can I go about achieving it?

Thanks a lot in advance
ibe

 

[IbeKaba]

LB, I completely understand where you are coming from. And you are right, my previous post made illustrated exactly how you understood it. I guess even I did not know what I needed. So, no it's was not your mistake, it was entirely mine. And I probably wouldn't have seen it had you not brought it to my attention.
I guess some times we have to know what we don't want before we even start to understand what we want.
I'm just amazed that somebody would take this much time and energy to help another person out. I guess if not in the real, there are still few good samaritans out there in the cyber world.
Thanks,
ibe

PS: synapsevampire, you too. Thanks for the help.