Username Field

[Jscott]

I need to autopopulate a username Field based on 3 different fields, but I want the username to be the first letter of the first name, the last name and the last 4 digits of their social.

First Name = John

Last Name = Doe

Social Security = 111-222-1234

Username = jdoe1234

Stumped!

[Fitch]

Here's your calc:

Lower( Left(First Name;1) & Last Name ) & Right(Social Security;4)

[Jscott]

Thanks Fitch!