By Richard Rost 2 years ago
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 will see how to write a custom VBA function to perform the same task, which I prefer.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Combining Names
Get notifications when this page is updated