ConcatRelated() in Access, using two keys

by

You could write it this way:

SELECT Distinct
  tbl.Chain,
  tbl.Store,
  ConcatRelated("Warehouse","tbl","Chain=""" & [Chain] & """ and Store=""" & [Store] & """") AS Warehouses
FROM tbl;

More Related Contents:

  1. Concatenating multiple rows into single line in MS Access [duplicate]
  2. ConcatRelated function in a query
  3. Combine values from related rows into a single concatenated string value
  4. Bang Notation and Dot Notation in VBA and MS-Access
  5. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  6. Is there a simple way of populating dropdown in this Access Database schema?
  7. How can I get table names from an MS Access Database?
  8. Is there any way to create multiple insert statements in a ms-access query?
  9. Running Microsoft Access as a Scheduled Task
  10. How to diagnose MS access crashes
  11. “Operation must use an updateable query” error in MS Access
  12. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  13. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  14. MS Access trigger?
  15. MS Access LIMIT X, Y
  16. Prevent enabling of shift bypass – Access 2010
  17. Access query producing results like ROW_NUMBER() in T-SQL
  18. Is MS Access (JET) suitable for multiuser access?
  19. Save password for ODBC connection to MS SQL server from MS Access 2007
  20. How to write Case Sensitive Query for MS Access?
  21. Setting up an MS-Access DB for multi-user access
  22. Access VBA: Find max number in column and add 1
  23. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  24. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  25. Custom row source for combo box in continuous form in Access
  26. VBA – Run Time Error 3271 using DAO object
  27. Working with multiple programmers on MS Access
  28. Trouble with InputBoxes
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment