How to add a text to an existing record in access through query

Question

I need to update a field in Access table through a query by keeping the text in the existing field and insert more text to the same field. I tried update to but it removes the content of the field and adds the new text. I need to keep the existing text.

Answer 1

Let's say your field is named TextField.

In an update query based on the table, set the 'Update to:' line of the TextField column to

[TextField] & " text to be added"

if you want to add the text after the existing text, or to

"text to be added " & [TextField]

if you want to add it before the existing text.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Hi, Heshamko

To append the text in existing record you can make your query like below given syntax.

UPDATE [TableName] SET [FieldName] = [FieldName] & 'Appended Text' WHERE [FieldName] = 'Match Record Text';

& is use to concatenate two strings.

UPDATE customertbl

SET lastname = lastname & ‘xyz’

WHERE firstname = 'abc';

For more information about update query visit the following link.     

information regarding update query

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.