Рет қаралды 2,680
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
• How to Use a Pass Thro...
How to Simulate Lag and Lead Window Functions
• How to Simulate Lag an...
How to Filter by Month in MS Access Queries, Forms, and Reports
• How to Filter by Month...
How to Use Reference Expressions to Get Form Values in MS Access
• How to Use Reference E...
How to Create String Aggregates in Microsoft Access
You are watching this video now!
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #vba