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.