For XML Path - to Concatenate records into View to Join to Primary ID (quickly!) | Access World Forums
![Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk](http://www.databasedev.co.uk/image/Pindaros_key_cover_WHITE.jpg)
Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk
![Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk](http://www.databasedev.co.uk/image/conditional_iif_concatenation.jpg)
Access 2007 Pure SQL - Conditional concatenation with the iif() function | Database Solutions for Microsoft Access | databasedev.co.uk
![concat SQL | concatenate in SQL - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy concat SQL | concatenate in SQL - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy](https://www.wikitechy.com/tutorials/sql/img/sql-images/sql-concat.png)
concat SQL | concatenate in SQL - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy
![Microsoft Access String Concatenation, Double Double Quotes, Single Quotes, Dates, Times TechHelp - YouTube Microsoft Access String Concatenation, Double Double Quotes, Single Quotes, Dates, Times TechHelp - YouTube](https://i.ytimg.com/vi/Y1B2W6VfWaw/hq720.jpg?sqp=-oaymwE7CK4FEIIDSFryq4qpAy0IARUAAAAAGAElAADIQj0AgKJD8AEB-AGACoAC0AWKAgwIABABGGUgWihcMA8=&rs=AOn4CLDYIFu7avs2fSt6OAcFCGLXnOXgUw)