Replacing data

[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

 

[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

all of F2 with "Failed" for all record in F1="Yes"

 

[bladelock]

Thank you and God Bless

 

[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

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.