Replacing data

B

bladelock

I have two fields in table, F1 and F2. I want to replace all of F2 with "Failed" for all record in F1="Yes"
Thanks
 
C

Chris Nebinger

Update TableName set F2="Failed" where F1="Yes"

Paste that into a query, and then run it. (always make a
backup copy of your db and/or table before running action
queries you aren't 100% sure of)

Chris Nebinger
-----Original Message-----
I have two fields in table, F1 and F2. I want to replace
Click to expand...
all of F2 with "Failed" for all record in F1="Yes"
 
J

John Vinson

I have two fields in table, F1 and F2. I want to replace all of F2 with "Failed" for all record in F1="Yes"
Thanks
Click to expand...

Create an Update query.

Create a Query based on your table; select the F1 and F2 fields.

Change the Query to an Update query using the query menu option (or
the query-type icon).

A new row will appear, labeled "Update To".

On the Criteria line put

="Yes"

under F1, and on the Update To line under F2 put

"Failed"

Run the query by clicking the ! icon.
 
Top