Re: 2000 MsACCESS concatenate: Combining multiple rows into one row



On Wed, 3 Jan 2007 21:59:05 -0800, ssophab
<ssophab@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Help Needed.
I'm trying to combine WorkCntr into one line for each part. Here's a table:

PartNo Operation# WorkCntr
81025745 10 INSPECT
81025745 20 SHIPPING
81029877 10 RAW MAT
81029877 20 MILL

I need this output:
PartNo Operation# WorkCntr
81025745 10 INSPECT; SHIPPING

Use the code (and instructions) at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]
.