Concatenating First and Last Names

[MB]

I have two fields: FirstName and LastName. I want to concatentate so the
results will be LastName, First Name. I added a column in my query and did
the following:

FullName:[LastName]&, "&[FirstName]

This works fine if all records contain a first and last name. If the record
does not, then only the comma shows. What should I write that will keep the
field blank if there is no first and last name?

Thank you for your help.

 

[Ofer Cohen]

Try

FullName: ([LastName]) & IIf([LastName] Is Null,[FirstName],(",
"+[FirstName]))

 

[MB]

Thank you for the quick response. The result I get is the last name with a
comma and no first name is showing up.

Example: Smith,

Instead of Smith, John


MB

Try

FullName: ([LastName]) & IIf([LastName] Is Null,[FirstName],(",
"+[FirstName]))

--
Good Luck
BS"D

I have two fields: FirstName and LastName. I want to concatentate so the
results will be LastName, First Name. I added a column in my query and did
the following:

FullName:[LastName]&, "&[FirstName]

This works fine if all records contain a first and last name. If the record
does not, then only the comma shows. What should I write that will keep the
field blank if there is no first and last name?

Thank you for your help.

 

[Ofer Cohen]

Mybe it's empty and not Null, try

FullName: ([LastName]) & IIf(Trim([LastName] & "") = "",[FirstName],(",
"+[FirstName]))

--
Good Luck
BS"D

Thank you for the quick response. The result I get is the last name with a
comma and no first name is showing up.

Example: Smith,

Instead of Smith, John


MB

Try

FullName: ([LastName]) & IIf([LastName] Is Null,[FirstName],(",
"+[FirstName]))

--
Good Luck
BS"D

I have two fields: FirstName and LastName. I want to concatentate so the
results will be LastName, First Name. I added a column in my query and did
the following:

FullName:[LastName]&, "&[FirstName]

This works fine if all records contain a first and last name. If the record
does not, then only the comma shows. What should I write that will keep the
field blank if there is no first and last name?

Thank you for your help.

 

[MB]

That did it!! Thank you!
--
MB

Mybe it's empty and not Null, try

FullName: ([LastName]) & IIf(Trim([LastName] & "") = "",[FirstName],(",
"+[FirstName]))

--
Good Luck
BS"D

Thank you for the quick response. The result I get is the last name with a
comma and no first name is showing up.

Example: Smith,

Instead of Smith, John


MB

Try

FullName: ([LastName]) & IIf([LastName] Is Null,[FirstName],(",
"+[FirstName]))

--
Good Luck
BS"D


:

I have two fields: FirstName and LastName. I want to concatentate so the
results will be LastName, First Name. I added a column in my query and did
the following:

FullName:[LastName]&, "&[FirstName]

This works fine if all records contain a first and last name. If the record
does not, then only the comma shows. What should I write that will keep the
field blank if there is no first and last name?

Thank you for your help.