how to concatenate part of a field

T

Ted Allen

Try: left([FirstName],1) & [LastName]

-Ted Allen
-----Original Message-----
Hello all,
I need to concatenate part of a field and join it with a
Click to expand...
another to create a username. So I need to join the first
letter of the [FirstName] field & [LastName] = to create
the [Username] field. I am trying to do it using the
expression builder can anyone offer me some help?
 
Top