Space between text calculation

[Wayne1158]

I have a calculation feild which gets the first initials and last name. However there is no white space between the initials or name, can anyone please suggest how I would do this, thanks.

Left ( LeftWords (Employee::First Name ; 1 ) ; 1) & Left ( LeftWords (Employee::Middle Name ; 1 ) ; 1) & Employee::Last Name

[comment]

The LeftWords() bit is redundant. Use literal text (i.e. text surrounded by commas) to add spaces, periods, etc. in-between, e.g.:

Left ( Employee::First Name ; 1 ) & ". " & Left ( Employee::Middle Name ; 1 ) & ". " & Employee::Last Name