Report Records from One Field Shown on One Line Separated by Commas

[zburns]

here's my dilemma.
Rather than use a line for each record I would like to have all on one line separated by a comma whereby saving many pages of printing. Grouping example:

Instead of this: Joseph
1.0
3.7
11.8
22.9

Have this: Joseph
1.0, 3.7, 11.8, 22.9 etc...

Any suggestions are greatly appreciated

[June7]

Review http://allenbrowne.com/func-concat.html

[zburns]

Looks like it might be what I need, however . . . .

Received a Compile Error - user-defined type not defined on Allan Browns' ConCatRelated public function
> Dim rs As DAO.Recordset <

any suggestions?

[zburns]

http://www.cimaware.com/resources/article_43.html

took care of the compile problem .

Now I will see how the function works

[June7]

That's very odd. DAO is now the default recordset type for Access (didn't use to be). Should not need to set a library reference and that line should not error. Allen's function is well-known and proven.

I do not reference the DAO library and my code works.