Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting concatenation of records

Status
Not open for further replies.
Bubsi

Bubsi

Technical User
Aug 27, 2002
21
DE
If somebody has an idea how I can realize the following data output I would be very thankful.

Table:
Project Pos Description
100001 1 aa
100001 5 ad
100001 29 bf
100002 1 cd
100002 15 be
100002 23 nf
100002 24 xc


Result:
100001 aa, ad, bf
100002 cd, be, nf, xc
 
Status
Not open for further replies.

Similar threads

caitlind
  • Locked
  • Question
‘Art of Indigenous Fashion’ showcases the works of Native American designers
Replies
0
Views
255
caitlind
caitlind
ebtrr
  • Locked
  • Question
Query last modify date/time of table row
Replies
1
Views
92
rum63
rum63
caitlind
  • Locked
  • Question
There are several kinds of dogs that the poor "can't accept", try not to consider them whe
Replies
0
Views
219
caitlind
caitlind
trsiskotr
  • Locked
  • Question
Paradox 9 on winxp all of a sudden printing all worksheets/tables from 2007
Replies
3
Views
131
simd01
simd01
Lewy
  • Locked
  • Question
adding records 1
Replies
1
Views
75
mjt39
mjt39

Part and Inventory Search

Sponsor

Back
Top