Combining Names of Couples with Nested IIFs

In this video, I will show you how to combine the names of couples if their last names are the same OR display them separately if different. We'll use Nested IIF functions.

William from Dallas, Texas (Paid TechHelp Question) asks: I'm working on a membership database where I would like to show a single name if there's only one person. If it's a couple, I'd like to combine them if their last names are the same. For example, I could have: John Smith OR John and Amy Smith OR John Smith & Amy Jones. How can I do this in Access?

Members

Members will see how to write a custom VBA function to perform the same task, which I prefer.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Paid TechHelp Questions: https://599cd.com/TechHelpPaid
• IIF Function: https://599cd.com/IIF
• Concatenate: https://599cd.com/Concatenation
• Self Join: https://599cd.com/SelfJoin
• Genealogy: https://599cd.com/Genealogy

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, married, couples, spouses, combine names, partners, iif function, nested iif functions, combine first last names couples, concatenate, same last name, different last name