Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update field with new vaules

Status
Not open for further replies.

joshryanhr

Technical User
Sep 6, 2009
13
US
Im trying to update a old vaule with a new vaule. old=disputed new=1disputed. I have about 30000 records that need this to be changed on. Is there a way to do this without having to create a whole new table?
 
Im kinda new at this, How would the update query be set up? I also so some things about a replace function but now sure how to make it work.
 
Code:
Update TableName SET FieldName = "NewValue" where FieldName = "OldValue"


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top