nz

  • Thread starter Thread starter Annnie
  • Start date Start date
A

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
 
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
 
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
Click to expand...


.
Click to expand...
 
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




Annie said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
whichever
one has a value?
Will there always only be one filled in?

If so, just string them together. The blank ones
Click to expand...
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


.
Click to expand...
Click to expand...


.
Click to expand...
 
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


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top