Concatenate column in rows into one string

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

I am looking for a way to take a set of rows and combine them into on string.
An example of what I want to do is below

Records:
entryid, blankid, class

1, 1, '002'
1, 1, '003'
1, 1, '004'
1, 2, '001'
1, 2, '002'
2, 1, '001'
2, 1, '004'
2, 2, '001'

I want to get to
1, 1, "002 003 004"
1, 2, "001 002"
2, 1, "001 004"
2, 2, "001"

I know how to do this in trans-act sql using a while loop but do not know
how to do this in access. I do not want them as separate columns like I could
get with a pivot table.

Any ideas?
 
Back
Top