Bonehead question about concatenating

[GingGangGoo]

I want an calculated field in my contacts table that brings together [LastName], and the first letter of [FirstName] and [ConID], so that I get SmithJ15. I know how to concatenate all three fields, what I can't figure out is how to express, return only first letter of FirstName.
BTW: I think this has something to do with a substring function - trying to research as I'm waiting for help.

 

[sneuberg]

I think the left function http://www.techonthenet.com/access/functions/string/left.php is what you are looking for.

 

[Alc]

= [LastName] & Left([FirstName],1) & [ConID]

 

[GingGangGoo]

= [LastName] & Left([FirstName],1) & [ConID]

Ah, that worked but FYI, in Access web the &'s are now +, so the expression that worked is: +[LastName]+Left([FirstName],1)+Right([Phone1],4)

I decided to use the last 4 of the phone #, instead of ID, and your solution helped me figure out to go from the right.

Thank you!!