Fullname text string creation.

[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....

 

[Dave - Freedonia]

You could try:
IIF(IsNull([Middlename]),[Firstname] & " " & [Lastname],[Firstname] & "
" & [Middlename] & " " & [Lastname])

HTH,
Dave