How to use In.. Not In.. to include or exclude multiple values in Microsoft Access

In this episode, we take a look at In and Not In, to allow us to filter our query or form based off of a few selections, or to exclude just a few selections as we need to. We'll also look at how to use In and Not In with select sub-queries so that your inclusion or exclusion is a bit more dynamic. This is a very powerful way to filter selections and as you do more development, you'll find that you use these methods more and more. Let's go! Related Videos: How to Make an Inner Join and Left Join in Microsoft Access and Learn How to Compare Lists    • How to Make an Inner Join and Left Join in...   How to Make a Query by Joining Tables and Making a Calculated Column in Microsoft Access    • How to Make a Query by Joining Tables and ...   How to Use an Append Query in MS Access: mdb to accdb    • How to Use an Append Query in MS Access: m...   Multi-Table Update Query in MS Access    • Multi-Table Update Query in MS Access   How Use Delete Queries in MS Access'    • How Use Delete Queries in MS Access   How to use In.. Not In.. to include or exclude multiple values in Microsoft Access You are watching this video now! How to Use Wildcards in MS Access Queries    • How to Use Wildcards in MS Access Queries   How to Use Double and Single Quotes in MS Access Queries    • How to Use Double and Single Quotes in MS ...   Avoid hidden costs and complexity. Get Virtual machines, S3 storage, and more, on your own cloud network. https://beaverdamtechnologies.ca Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-... Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :   / mackenziedataengineering   Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-... Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media:   / mackenziedataanalytics     / seamacke     / seamacke     / seamacke     / psmackenzie   Thank you to my viewers! Mention Promo Code SMDE25TWELVE for 25% off a twelve-month virtual machine subscription at: https://beaverdamtechnologies.ca Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenz... #msaccess #sql    • How to use In.. Not In.. to include or exc...