Pull letters of a text string

  • Thread starter Thread starter Ezra
  • Start date Start date
E

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.
 
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
 
Back
Top