AnsweredAssumed Answered

Combining multiple records

Question asked by DavidEnns on Jan 1, 2012
Latest reply on Jan 3, 2012 by DavidEnns

Title

Combining multiple records

Post

I have an obstacle table with fields trail_ID, Obstacle_ID and Description.

Record 1: 0001, 01, qwerty

Record 2: 0001,02, help me

record 3: 0002, 01, nice

 

What I'm trying to do is combine all the description records from one trail into one field for printing purposes.

trail_ID=0001 obstacle_ID=01

trail_ID=0001 obstacle_ID=02

result=qwerty help me

Outcomes