|
||||||
|
Combining Names By Richard Rost 3 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
Keywordsmicrosoft 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
|
||||||||||||||||
| |||
Keywords: TechHelp Access married, couples, spouses, combine names, partners, iif function, nested iif functions, combine first last names couples, concatenate, same last name, different last name PermaLink Combining Names in Microsoft Access |