lwarren1968
Registered User.
- Local time
- Yesterday, 22:49
- Joined
- Jan 18, 2013
- Messages
- 77
i need to write an expression that combines several groups of fields, however if any of the "last name" fields are empty I do not want to include that group? Thoughts?
=[merchant no 1] & " " & [first name1]& " " & [last name1] & " " & [merchant no 2]& " " & [first name2] & " " [last name2]
=[merchant no 1] & " " & [first name1]& " " & [last name1] & " " & [merchant no 2]& " " & [first name2] & " " [last name2]