Fullname text string creation.

  • Thread starter Thread starter DPCpresto
  • Start date Start date
D

DPCpresto

I need help on the proper syntax for concatenating names. Specifically, I need to create a [Fullname] field from [Firstname], [Middlename], [Lastname]. I can do that easily enough, but seem to be lost as to how best to strip out the extra spaces if there is no [Middlename]. So really what I want is the regular spacing in the [Fullname] field whether there is a [Middlename] or not. Thanks for your ideas....
 
You could try:
IIF(IsNull([Middlename]),[Firstname] & " " & [Lastname],[Firstname] & "
" & [Middlename] & " " & [Lastname])

HTH,
Dave
 
Back
Top