Скачать с ютуб How to Make a Combination Query in Microsoft Access в хорошем качестве

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... Check out my easy time entry system for your business: https://system.billzone.com/billzone Join me on Patreon!   / mackenziedataengineering   Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmacken... 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://system.billzone.com/smdeproje... Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media:   / mackenziedataanalytics     / seamacke     / seamacke     / seamacke     / psmackenzie   Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/... Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenz... #msaccess #dataengineering