String aggregates allow us to make a query that will have many rows of one field aggregated into a single, delimited field. For example, a list of cars with available colors, a class with a list of student names, a hamburger with a list of toppings and more. Many popular databases like SQL Server and SQLite include a function for this type of query, but MS Access does not. In this episode I will demonstrate one way to write this function in VBA, so that you can create queries with delimited list fields. Related Videos: How to Use a Pass Through Query in MS Access - SQL Server Example https://www.youtube.com/watch?v=JCeEBb3mR7E How to Simulate Lag and Lead Window Functions https://www.youtube.com/watch?v=9iSuI3dR75o How to Filter by Month in MS Access Queries, Forms, and Reports https://www.youtube.com/watch?v=c45ny4vQGFs How to Use Reference Expressions to Get Form Values in MS Access https://www.youtube.com/watch?v=I2JU95lnz_w How to Create String Aggregates in Microsoft Access You are watching this video now! Join me on Patreon! https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want the code from this video? http://mackenziemackenzie.com/downloads For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vba