Appending query results to a single text string

OK,... I need your help programmers! I have a table that shows all of the different events a competitor is registered in. I am trying to create a report that will show the competitors of the current event on a single line with a string that is all the other events entered. For example:

I am registered in event 10, as are 20 others. The report will list the 21 competitors each on a single line. I want one of the columns of the report to return all other events that I am registered in. Because the report contains multiple competitors, the challenge is to get this info in a single character string or "field" value rather than a vertical listing of each event.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!