Jump to content

How to amend data to an existing DB fleld


Martinl3
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...