Simple Concatenation Query

[Guest]

I have a query to combine First Middle and Last name:
FullName: Table!First+" "+Table!Middle+" "+Table!Last.

This works if someone has all 3 (First, Middle and Last) names, BUT WONT
display any name at all If someone doesnt have a middle initial. For these
people, i would like it to show a First and Last name only.

Thank you!

 

[Guest]

Try this --

FullName:

.[First]+IIF(

.[Middle] Is Null,"","
"+

.[Middle]) +" "+

.[Last]

 

[Guest]

Works perfectly. Thank you.

Try this --

FullName:

.[First]+IIF(

.[Middle] Is Null,"","
"+

.[Middle]) +" "+

.[Last]

I have a query to combine First Middle and Last name:
FullName: Table!First+" "+Table!Middle+" "+Table!Last.

This works if someone has all 3 (First, Middle and Last) names, BUT WONT
display any name at all If someone doesnt have a middle initial. For these
people, i would like it to show a First and Last name only.

Thank you!

 

[Brian Bastl]

You may also try the following, which (according to my tests) will keep the
text left-aligned and properly spaced regardless of which field(s) may be
empty.

MoneyBags: Trim((PerFirst+" ") & ( PerMiddle + " ") & (PerLast))

HTH,
Brian

Works perfectly. Thank you.

Try this --

FullName:

.[First]+IIF(

.[Middle] Is Null,"","
"+

.[Middle]) +" "+

.[Last]

I have a query to combine First Middle and Last name:
FullName: Table!First+" "+Table!Middle+" "+Table!Last.

This works if someone has all 3 (First, Middle and Last) names, BUT WONT
display any name at all If someone doesnt have a middle initial. For these
people, i would like it to show a First and Last name only.

Thank you!