How to amend data to an existing DB fleld

[Martinl3]

I have ASP pages working with a Microsoft Access DB and I am trying to use my SQL to amend data in a field.  I use the Update function to replace data in a field but I can't find a function that will add new data to the existing data in a field.  Is there a way to do this?

Thank you in advance.

Martinl3

[niche]

Here’s what you need;

https://www.w3schools.com/sql/sql_update.asp

[Martinl3]

Thank you for replying but this UPDATE function, in my experience as well the examples on the page you referenced will overwrite (replace) the existing data.  I want to keep data that already exists in the field and be able to add new data to it.  Maybe this is something SQL does not allow.

 

[Ingolme]

I replied to your original topic earlier.

 

[niche]

Fox hit the nail on the head.  I would respectfully add,  focus on the WHERE keyword.