Update a field with 3 characters from another field

Hi
I would like to update a field with the first 3 characters from another field
the field to get the first 3 characters from is [Item Reference]
Not sure how this should read in the update query
Gordon
Gordon HughesDirectorAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
using an update query

update TableName
set [fieldname]=Left([Item Reference],3)

Open in new window

or with a criteria

update TableName
set [fieldname]=Left([Item Reference],3)
where [fieldname] is null

Open in new window

0
 
NorieVBA ExpertCommented:
Gordon

Are the 3 characters  to replace the current value in the field?
0
 
Gordon HughesDirectorAuthor Commented:
Thanks for the speedy response
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.