Ms Access Query: Concatenating Rows through a query

by

You need a function to do the concatenation.

Microsoft Access condense multiple lines in a table

Example using your data:

Select T.ColumnA
  , GetList("Select ColumnB From Table1 As T1 Where T1.ColumnA = " & [T].[ColumnA],"",", ") AS ColumnBItems
From Table1 AS T
Group By T.ColumnA;

More Related Contents:

  1. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  2. SQL multiple join statement
  3. Is there any difference between GROUP BY and DISTINCT
  4. How to use count and group by at the same select statement
  5. MySQL Results as comma separated list
  6. must appear in the GROUP BY clause or be used in an aggregate function
  7. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  8. Concatenate row values T-SQL
  9. How to do INSERT into a table records extracted from another table
  10. GROUP BY to combine/concat a column [duplicate]
  11. Multiple INNER JOIN SQL ACCESS
  12. JOIN two SELECT statement results
  13. Oracle SQL, concatenate multiple columns + add text
  14. Group by month and year in MySQL
  15. is there a group_concat function in ms-access?
  16. Concatenate and group multiple rows in Oracle [duplicate]
  17. SQL Group by & Max
  18. Concat field value to string in SQL Server
  19. How do I implement pagination in SQL for MS Access?
  20. PostgreSQL Where count condition
  21. SQL to add column with default value – Access 2003
  22. GROUP BY without aggregate function
  23. How can I implement SQL INTERSECT and MINUS operations in MS Access
  24. Get values from first and last row per group
  25. How to return a incremental group number per group in SQL
  26. How to get list of values in GROUP_BY clause?
  27. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  28. SQL SET DEFAULT not working in MS Access
  29. Access substitute for EXCEPT clause
  30. Concat all column values in sql

Leave a Comment