Pull letters of a text string

[Ezra]

I have two fields, First and Last name. I am traing to get
a third field that is made up of the 1st initial and the
first 4 letters of the last name.
So i would get:
FName LName NCode
Joe Johnson JJOHN

How can i accomplish this?
Thank you in advance.

 

[JulieD]

Hi Ezra

add the NCode field into your table
then run an update query
where you update NCode to
UCASE(Left([tblname].[FName],1) & Left([tblname].[LName],4))
where tblname is the name of the table with FName and LName in it

Cheers
JulieD

 

[Cheryl Fischer]

Try this:

NCode: Left([FName], 1) & Left([LName], 4)


hth,

 

[Cheryl Fischer]

Try this:

NCode: UCase(Left([FName], 1) & Left([LName], 4))


hth,