3 Fields: First, MI , Last Name = UserID

[GregSmith]

I have 3 fields that the user fills in.

[1] First Name
[2] MI
[3] Last Name

What I need is it to pull the 1st six letters of the last name and the MI and the 1st character of the first name.

Example: Steven M Cunningham
Would be: cunninsm

 

[cogent1]

Left([Last name],6)&[MI]& Left([First Name], 1)

 

[TessB]

cogent gave you exactly what you asked for. But your example returns something different.

Modify cogent's code thus if you want it to fit into your example.

Left([Last name],6)& Left([First Name], 1)&[MI]

 

[GregSmith]

It works great!!

One more question, if the user types in uppercase, how can I tell it to display the name in lowercase?

 

[TessB]

LCase(Left([Last name],6)& Left([First Name], 1)&[MI])

For future reference, UCase is used to turn lower case into Upper Case.

And Right([fieldname], n) works just like the Left function where n represents the number of characters you wish to extract from the RIGHT side of a string.