Should be simple......

[Guest]

5 Fields
First, Middle, Maiden, Last, Suffix

I have managed to build an expression that would put all 5 fields together
with spaces. However, what I need is an expression that would "skip" a NULL
field, the trailing space and the comma if the Suffix field is NULL.

Here is what I have:
Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]&", "&[Suffix])

Any ideas out there?

 

[DebbieG]

Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]& (", "+[Suffix]) )

Not sure you need the TRIM.

HTH,
Debbie


message |5 Fields
| First, Middle, Maiden, Last, Suffix
|
| I have managed to build an expression that would put all 5 fields together
| with spaces. However, what I need is an expression that would "skip" a
NULL
| field, the trailing space and the comma if the Suffix field is NULL.
|
| Here is what I have:
| Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]&", "&[Suffix])
|
| Any ideas out there?

 

[Rick B]

You have to use an IF statement for each item. Something like...


Expr1: [First] & IIF([Middle]<>"",[Middle]&" ","") &...

 

[DebbieG]

Thought you might like to see how to code if Middle and Maiden are blank
also.

Expr1: TRIM([First] & (" "+[Middle]) & (" "+[Maiden]) & " " &[Last] & (",
"+[Suffix]) )

HTH,
Debbie


| Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]& (",
"+[Suffix]) )
|
| Not sure you need the TRIM.
|
| HTH,
| Debbie
|
|
in
| message ||5 Fields
|| First, Middle, Maiden, Last, Suffix
||
|| I have managed to build an expression that would put all 5 fields
together
|| with spaces. However, what I need is an expression that would "skip" a
| NULL
|| field, the trailing space and the comma if the Suffix field is NULL.
||
|| Here is what I have:
|| Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]&", "&[Suffix])
||
|| Any ideas out there?
|
|

 

[Guest]

Rick,

Thank you so much. Wish I had posted this question 2 hours ago.

B

You have to use an IF statement for each item. Something like...


Expr1: [First] & IIF([Middle]<>"",[Middle]&" ","") &...

5 Fields
First, Middle, Maiden, Last, Suffix

I have managed to build an expression that would put all 5 fields together
with spaces. However, what I need is an expression that would "skip" a NULL
field, the trailing space and the comma if the Suffix field is NULL.

Here is what I have:
Expr1: TRIM([First]&" "&[Middle]&" "&[Maiden]&" "&[Last]&", "&[Suffix])

Any ideas out there?

 

[Guest]

Perfect solution. Thanks for your help. VERY EASY to do.