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.com/posts/how-to-...
Want the code from this video?
mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a KZitem Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#msaccess #vba
Негізгі бет How to Create String Aggregates in Microsoft Access
Пікірлер: 20