Martinl3

Thank you. I will check it out

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.

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

I have a website using ASP pages and a Microsoft Access DB using SQL to manage the interface. I want to add the option to add to existing data in a specific field instead of replacing that data. I know how to use the UPDATE function to replace the data in a field but I want to add to that data, not replace it. I have been retired for 6 years and had no reason to stay up on these items but now I have the need again and am really rusty. Thank you in advance.