Concatenation Access


Im looking to update a field in an access table using concatenate.

My field currently contains "123" i want it to contain "123USABC"

How do i concatenate and replace?

Who is Participating?
Lee W, MVPConnect With a Mentor Technology and Business Process AdvisorCommented:
If the field is numeric then you'll have to change it to a character based field.
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
just like what was suggested by Lee,
change the Data type of the field to Text if it is Number Data Type

you can use an update query to change the values

Update TableX
set [fieldname]=[fieldname] & "USABC"

or adding a where condition

Update TableX
set [fieldname]=[fieldname] & "USABC"
where <condition goes here>
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.