Hi All,
I'd like to take the data from a query and list it with commas in a report text box.
Query data
Record # Value
1 A
2 B
3 C
4 A
5 B
I'd like to display the results as "A, B, C, A, B"
I know there will never be more that 7 records and each Value will always be 1 character.
Do I have to run the in VBA code Do While Loop? or are there other options with a subreport?
Thanks.
I'd like to take the data from a query and list it with commas in a report text box.
Query data
Record # Value
1 A
2 B
3 C
4 A
5 B
I'd like to display the results as "A, B, C, A, B"
I know there will never be more that 7 records and each Value will always be 1 character.
Do I have to run the in VBA code Do While Loop? or are there other options with a subreport?
Thanks.