G Guest May 17, 2004 #1 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
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 May 17, 2004 #2 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"
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 May 20, 2004 #4 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.
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.
