Need help combining fields

[cajun]

I need to combine the following
FirstName
Middle
LastName

The results I am looking for are the First Letter of the FirstName, First Letter of the Middle, and the full LastName

I know that I can do a FirstName & Middle & Last = initials, but I don't know how to get just the first letter of the FirstName & Middle fields.

[PEB]

You can use the function left(FirstName, 1)+left(MiddleN ame,1)+FamillyN ame :)

[MMcCarthy]

I would use & rather than +.

left(FirstName, 1) & " " & left(MiddleName ,1) & " " & FamillyName

You can use the function left(FirstName, 1)+left(MiddleN ame,1)+FamillyN ame :)