How to Make a Combination Query in Microsoft Access

In this episode, we take a look at how to make combinations between items in a table, using sports teams as an example. If you have n teams in your league, how can you make a query that shows you a single game between each team with every other team? If you are in a manufacturing context where every part must have an operation with every other part in a set, how can you show that? A combination query can do this for you, and it is quite a powerful tool for many use-cases requiring a binomial coefficient solution. While this problem (and associated use cases) can be solved with looping or recursion, today, we'll explore how to do this with a query in Microsoft Access. Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker: https://buy.billzone.com/bzrdpcloaker.html Check out my easy time entry system for your business: https://system.billzone.com/billzone Join me on Patreon! https://www.patreon.com/mackenziedataengineering Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmackenziedataengineering Want the code from this video? http://mackenziemackenzie.com/downloads Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects.html 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 #dataengineering