Multiple Records Consolidated to one

[Halter_joel]

Hi All,


I am new to access, but i'm working with someone who has been using it for years and we're both stumped on this senario.
Heres an example of what i'm trying to accomplish.

CustomerID	Atrraction	SeatID	SectionName	RowLabel	SeatLabel			CustmerID	Atraction	SectionName	RowLabel	SeatLabel
10	2	14	G Right	B	2	Want it to look like this		10	2	G Right	B	2-4
10	2	15	G Right	B	3			10	3	G Right	B	2-4
10	2	16	G Right	B	4			11	2	A Center	H	20-22
10	3	14	G Right	B	2			11	3	A Center	H	20-22
10	3	15	G Right	B	3
10	3	16	G Right	B	4
11	2	200	A Center	H	20
11	2	201	A Center	H	21
11	2	202	A Center	H	22
11	3	200	A Center	H	20
11	3	201	A Center	H	21
11	3	202	A Center	H	22

Mainly i Want it to take the seats that have the same SectionName, Same RowLabel and Consolidate the Records by Adding the consecitive Seats Together.

Do you guys have any thoughts?????

[pbaldy]

This isn't the solution, but I think could be adapted:

http://allenbrowne.com/func-concat.html

basically you'd grab the first and last values and put them together. You'd need some logic to handle single records, plus to ensure contiguous values. Might be enough for your friend to get started anyway.