How create a field where the nickname is used instead of the first

[jmuirman]

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.

Here's what I'm working with:

Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

Thanks,

John

 

[fredg]

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.

Here's what I'm working with:

Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

Thanks,

John

Expr1: IIf(IsNull([CNickName]),[CFirstName], [CNickname])

 

[Olduke]

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.

Here's what I'm working with:

Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

Thanks,

John

Try
Expr1: IIF([Tcontacts_2.CNickname]<>" "[tContacts_2.CFirstName]+"" &
[tContacts_2.CNickname],[tContacts_2.CFirstName])

This is telling the expression that if nickname is not null, use the
firstname and nickname, otherwise use the first name.

I think I got the bracketting and everything correct.

 

[jmuirman]

Perfect! Thanks,

John

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.

Here's what I'm working with:

Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

Thanks,

John

Expr1: IIf(IsNull([CNickName]),[CFirstName], [CNickname])

 

[jmuirman]

Thanks for your help!

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.

Here's what I'm working with:

Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

Thanks,

John

Try
Expr1: IIF([Tcontacts_2.CNickname]<>" "[tContacts_2.CFirstName]+"" &
[tContacts_2.CNickname],[tContacts_2.CFirstName])

This is telling the expression that if nickname is not null, use the
firstname and nickname, otherwise use the first name.

I think I got the bracketting and everything correct.