is there a group_concat function in ms-access?

by

You should ask yourself if you need a generic solution (another is by Allen Browne) or if you need it just for the present purpose. If you really only need it this once, do it the easy way.

On a side note, when concatenating lists in VBA code, take advantage of a trick taught to me by long-time Access guru Trevor Best, and that’s to stick the delimiter at the beginning of every value and then use Mid() to strip it off. Instead of this inside your loop through the child records:

  If Len(strOutput) = 0 Then
     strOutput = NewValue
  Else
     strOutput = strOutput & ", " & NewValue
  End If

…use this inside the loop:

  strOutput = strOutput & ", " & NewValue

…and then when you exit the loop, strip off the leading delimiter:

  strOutput = Mid(strOutput, 3)

This has implications all over the place and simplifies code for concatenation in a whole host of contexts.

More Related Contents:

  1. How do I create a table alias in MySQL
  2. sql in ms-access [closed]
  3. Join vs. sub-query
  4. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  5. Natural Sort in MySQL
  6. MySQL get row position in ORDER BY
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. How do I write a full outer join query in access
  10. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  11. MySQL unknown column in ON clause
  12. MySQL not using indexes with WHERE IN clause?
  13. SQL: Find the max record per group [duplicate]
  14. Group by month and year in MySQL
  15. Maintaining order in MySQL “IN” query
  16. MySQL: What is a reverse version of LIKE?
  17. Select TOP X (or bottom) percent for numeric values in MySQL
  18. How to create a multi-tenant database with shared table structures?
  19. MySQL select where column is not empty
  20. Hamming distance on binary strings in SQL
  21. Is it possible to have a default parameter for a mysql stored procedure?
  22. Renaming foreign-key columns in MySQL
  23. How to convert from varbinary to char/varchar in mysql
  24. MySQL GROUP BY behavior
  25. Convert String to Date in MS Access Query
  26. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  27. Update multiple rows with one query?
  28. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  29. How do MySQL views work?
  30. How do I perform update query with subquery in Access?

Leave a Comment