Help: Combining Field Names 1

[RDM23]

I have 3 fields I am trying to combine. These are name fields such as Last Name, First Name, Initials, I am able to combine these using this formula.
Name: [Last Name]+", "+[First Name]+" "+[Initials]

My issue is, sometimes the Initials field is blank. How would I write the formula to still produce the output of Last Name, First Name even if the Initials field was blank. Thanks in advance for any assistance.

 

[dhookom]

Concatenating strings is usually accomplished with & rather than +. Try
FullName: [Last Name] & ", " & [First Name] & " " + [Initials]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[RDM23]

That worked perfectly. Thanks so much your help dhookom!!!