Print employee's name in one row.....

[hengsin]

One table with Employee ID and Employee Name. I want the employee's name to look like this in the report:

Name1, Name 2, Name 3, Name 4...

i.e. it is printed in one row and separated with a comma. If i doing using Report Wizard, it will look like this:

 

[scriverb]

Do you want the names of all employees in the table to be listed horizontally seperated by commas? Is that what you would like? How many records are we talking about? Should they be displayed in a TextBox on a report? Please explain a little further. Bob Scriver

 

[hengsin]

Yes, all the name are listed horizontally separated by the comma. It's not display as text box. The employee database will be get from HR department. There are over one thousand. This application will be use as the meeting minute database. The purpose on this kind of display is to list out the all attendee on the report.

 

[scriverb]

I am still confused a little. In the report what kind of control are you going to use to display this list of names? This is going to be a huge area on a report. Why would you want to list them this way? Bob Scriver

 

[hengsin]

As i said, the database i am developing is the Meeting Minute database. The main purpose i want to display in this way because i want to list out all the attendee in one row rather than each name in each row. For example:
Name1
Name2
Name3
Name4

When i used the report wizard, it will generate in this way for me.

The attendee is another subreport i used in another main report.