Table Data in a text box 1

[vlingen]

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.

 

[dhookom]

Consider faq701-4233.

Duane
Hook'D on Access
MS Access MVP

 

[vlingen]

Thank-you that worked great!