Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Data in a text box 1

Status
Not open for further replies.

vlingen

Programmer
Aug 4, 2006
31
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top