Minddumps
Registered User.
- Local time
- Today, 02:55
- Joined
- Jul 5, 2011
- Messages
- 73
[SOLVED] How? Concatenate fields if Null/0 OR concatenate "these" fields instead if..
How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT null/0
Ok, I'm a bit stuck on figuring this out. In fact I don't even know how to word it to look for the solution since nothing I've come across quite relates completely.
I'm trying to work on a mail merge and one of my query columns says:
However, for my Mail Merge expression, I'm wanting something like this:
How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT null/0
Ok, I'm a bit stuck on figuring this out. In fact I don't even know how to word it to look for the solution since nothing I've come across quite relates completely.
I'm trying to work on a mail merge and one of my query columns says:
Code:
NameFull: [AllPOCs**].[Title] & " " & [POC First] & " " & [MI] & " " & [POC Last]
Anyone come across this type of issue before and can help me with the code?MergeName: If [AllPOCs**].[Title] is not empty or null, then = [AllPOCs**].[Title] & " " & [POC Last], but if [AllPOCs**].[Title] IS EMPTY then = [POC First]
Last edited: