How to Use Iif in Microsoft Access

In this episode, we look at how to use the Iif, or iif function in Microsoft Access to allow us a very quick if-then return value in our queries, forms, reports, and VBA code. The Iif function is very powerful, and will help you get values when you need "if condition is true then return this, otherwise return that"! Related Videos: Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules    • Getting Started with MS Access Visual...   VBA MsgBox - How to use message boxes in MS Access    • VBA MsgBox - How to use message boxes...   How to Use a Do Until Loop in MS Access VBA    • How to Use a Do Until Loop in MS Acce...   How to Use Iif in Microsoft Access You are watching this video now! How to Use the Replace Function in Microsoft Access    • How to Use the Replace Function in Mi...   How to Use Nz in Microsoft Access to Handle Null and Empty Values    • How to Use Nz in Microsoft Access to ...   Iif, If Then Else, and Select Case in MS Access    • Iif, If Then Else, and Select Case in...   How to Use DLookup in Microsoft Access    • How to Use DLookup in Microsoft Access   How to Create and Configure a Custom Pop-Up Form in MS Access    • How to Create and Configure a Custom ...   Interested in transforming your career or finding your next gig? system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! system.billzone.com/smdeprojects.html Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: www.patreon.com/posts/how-to-block-rdp-98471703?ut… Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at www.mackenziemackenzie.com/ Follow me on social media: www.facebook.com/mackenziedataanalytics twitter.com/seamacke www.instagram.com/seamacke/ www.reddit.com/user/seamacke www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&… Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: www.tubebuddy.com/seanmackenziedataengineering

• #education
• #iif
• #vba_iif
• #ms_access_iif
• #access_iif
• #expression_iif
• #ms_access_if_then
• #ms_access
• #iif_function
• #sean_mackenzie_data_engineering
• #sean_mckenzie_data_engineering