I'm not entirely sure the title makes sense.

First, I'm using Microsoft Access 2000. An example from my table as it currently sits:

Code:
Value 1	Value 2	Value 3
11111	A	
11112	B	
11113	C	
11114	A	
11115	A	
11116	C	
11117	B	
11118	A	
11119	B	
11120	B	
11121	A
Eventually, I'll need to run a group by on this table, using Value 1 twice to get the first value and last value in a range, and the group by will be on Value 2. However, by just running a simple group by, I'm going to have a ton of overlap, which I can't have.

What I need is this:

Code:
Value 1	Value 2	Value 3
11111	A	1
11112	B	2
11113	C	3
11114	A	4
11115	A	4
11116	C	5
11117	B	6
11118	A	7
11119	B	8
11120	B	8
11121	A	9
Essentially, any time there's a change in value 2, assign a new sequence number to value 3. That way, when I run my group by, I'll get this:

Code:
First of Value 1	Last of Value 1	Value 2	Value 3
11111	            11111	             A	1
11112	            11112	             B	2
11113	            11113	             C	3
11114	            11115	             A	4
11116	            11116	             C	5
11117	            11117	             B	6
11118	            11118	             A	7
11119	            11120	             B	8
11121	            11121	             A	9
Currently, the only way I know of to achieve this result is to go through and assign a new sequence number to value 3 by hand. I'm hoping there's an easier way to do this as the table is over 5000 records with probably 1000 sequence changes.

Any help would be greatly appreciated.