CraigDouglas
Registered User.
- Local time
- Today, 13:59
- Joined
- Sep 14, 2016
- Messages
- 31
Not sure where to ask my question? I am working on my database and have a formula that puts the company name in if there is no information in the FirstName & Surname field. My problem is that I also want it to take into account the middle name field. I messed around with the formula and tried to get it to put the company name if there is no FirstName, MiddleName & Surname. Here is the formula I have:
FullName: IIf(IsNull([CustomerSurname]),IIf(IsNull([CustomerFirstName]),[CustomerCompanyName],[CustomerFirstName]),IIf(IsNull([CustomerFirstName]),[CustomerSurname],[CustomerFirstName] & " " & [CustomerSurname]))
FullName: IIf(IsNull([CustomerSurname]),IIf(IsNull([CustomerFirstName]),[CustomerCompanyName],[CustomerFirstName]),IIf(IsNull([CustomerFirstName]),[CustomerSurname],[CustomerFirstName] & " " & [CustomerSurname]))