Displaying data in one text box in MS Access Report

[FA]

Hi Friends,
I have a question i dont know if its a legit question or not. I have a
report that has only one column and a chart in the botton of the
report. The column name is System Name and control source is SYS_NME.
Lets say, in one report there are 10 system names, I want to display
all the SYS_NME in one text box instead of having each row for each
SYS_NME. Is it possible?

Your help and suggestions would be greatly appreciated.

Thanks
Moe

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web" for one way to concatenate them into a single field.