nz

[Annnie]

Hi. I am trying to say that the Mailing Name is either
the NickName or FirstName, OR the ContactNickName or
ContactFirstName. I'm having problems with syntax and
would appreciate suggestions. Thanks, Annie

 

[Rick B]

Well, are you saying that you want to display whichever one has a value?
Will there always only be one filled in?

If so, just string them together. The blank ones won't be seen...

=[MailingName] & [NickName] & [FirstName] & [ContactNickName] &
[ContactFirstName]


Rick B

 

[Annie]

Hmm. That gave me: John, JimJames, and SusieSusan.

-----Original Message-----
Well, are you saying that you want to display whichever one has a value?
Will there always only be one filled in?

If so, just string them together. The blank ones won't be seen...

=[MailingName] & [NickName] & [FirstName] & [ContactNickName] &
[ContactFirstName]


Rick B

Hi. I am trying to say that the Mailing Name is either
the NickName or FirstName, OR the ContactNickName or
ContactFirstName. I'm having problems with syntax and
would appreciate suggestions. Thanks, Annie

.

 

[Rick B]

Well, then again I ask, How do you know which one you want to use?
Obviously you have a value stored in more than one field (JimJames) so How
do you want to decide which one to use? Which one takes priority? Will one
always have a value? Explain please.


Rick B

Hmm. That gave me: John, JimJames, and SusieSusan.

-----Original Message-----
Well, are you saying that you want to display whichever one has a value?
Will there always only be one filled in?

If so, just string them together. The blank ones won't be seen...

=[MailingName] & [NickName] & [FirstName] & [ContactNickName] &
[ContactFirstName]


Rick B

Hi. I am trying to say that the Mailing Name is either
the NickName or FirstName, OR the ContactNickName or
ContactFirstName. I'm having problems with syntax and
would appreciate suggestions. Thanks, Annie

.

 

[Guest]

NickName wins out. I am currently using
Member Name: Nz([NickName],[FirstName])

However I have Companies that have contacts with
ContactNickName and ContactFirstName.

If there is a NickName, there is not a ContactNickName.
Same for (...)FirstName. However, if there is a NickName
there is most likely a FirstName.

I want one mailing label: if there is a "member" I want
the NickName else the FirstName. if there is a "contact"
I want the ContactNickName else the ContactFirstName.

Thanks, Annie

-----Original Message-----
Well, then again I ask, How do you know which one you want to use?
Obviously you have a value stored in more than one field (JimJames) so How
do you want to decide which one to use? Which one takes priority? Will one
always have a value? Explain please.


Rick B

Hmm. That gave me: John, JimJames, and SusieSusan.

-----Original Message-----
Well, are you saying that you want to display

whichever
one has a value?

Will there always only be one filled in?

If so, just string them together. The blank ones

won't
be seen...

=[MailingName] & [NickName] & [FirstName] & [ContactNickName] &
[ContactFirstName]


Rick B




Hi. I am trying to say that the Mailing Name is either
the NickName or FirstName, OR the ContactNickName or
ContactFirstName. I'm having problems with syntax and
would appreciate suggestions. Thanks, Annie


.

.

 

[John Spencer (MVP)]

You can nest the NZ. For instance,

NX(ContactNickName,NZ(ContactName,NZ(NickName,FirstName)))

That will give the first of the follwing that is not null
ContactNickName
ContactName
NickName
FirstName

If you want a different priority then you just change the order in the NZ functions.

NickName wins out. I am currently using
Member Name: Nz([NickName],[FirstName])

However I have Companies that have contacts with
ContactNickName and ContactFirstName.

If there is a NickName, there is not a ContactNickName.
Same for (...)FirstName. However, if there is a NickName
there is most likely a FirstName.

I want one mailing label: if there is a "member" I want
the NickName else the FirstName. if there is a "contact"
I want the ContactNickName else the ContactFirstName.

Thanks, Annie

-----Original Message-----
Well, then again I ask, How do you know which one you want to use?
Obviously you have a value stored in more than one field (JimJames) so How
do you want to decide which one to use? Which one takes priority? Will one
always have a value? Explain please.


Rick B

Hmm. That gave me: John, JimJames, and SusieSusan.

-----Original Message-----
Well, are you saying that you want to display whichever
one has a value?
Will there always only be one filled in?

If so, just string them together. The blank ones won't
be seen...

=[MailingName] & [NickName] & [FirstName] &
[ContactNickName] &
[ContactFirstName]


Rick B




message
Hi. I am trying to say that the Mailing Name is either
the NickName or FirstName, OR the ContactNickName or
ContactFirstName. I'm having problems with syntax and
would appreciate suggestions. Thanks, Annie


.

.