Access queries Group By should allow Concatenate

[Guest]

Similar to the Sum function in Group By queries (Totals) it should be
possible to concatenate text fields within the group. For example: if I have
three records with the same group ID I and each have text in the query field:
TextA the result should be TextA(1) & TextA(2) & TextA(3).

 

[Marshall Barton]

Similar to the Sum function in Group By queries (Totals) it should be
possible to concatenate text fields within the group. For example: if I have
three records with the same group ID I and each have text in the query field:
TextA the result should be TextA(1) & TextA(2) & TextA(3).

It should be, but it isn't :-(

You can use a UDF to concatenate the group's data.

Here's Duane's function:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

or you can Google for several others.