Access queries Group By should allow Concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
drkpotter said:
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).
Click to expand...


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.
 
Back
Top