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!

Categories