Martinl3
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by 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.
-
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.
Adding info to an existing DB field using SQL
in General
Posted
Thank you. I will check it out