StacyStacy A "Californian" at heart! Local time Today, 04:03 Joined Jan 29, 2003 Messages 159 Jan 30, 2003 #1 Convert fields that contain a "1" into "YES". In this database, "1" means "YES". Thanks, StacyStacy
J Jack Cowley Registered User. Local time Today, 10:03 Joined Aug 7, 2000 Messages 2,636 Jan 31, 2003 #2 An Update Query will do the trick for you. Search Help for Update Query for instructions and examples. hth, Jack
An Update Query will do the trick for you. Search Help for Update Query for instructions and examples. hth, Jack
StacyStacy A "Californian" at heart! Local time Today, 04:03 Joined Jan 29, 2003 Messages 159 Jan 31, 2003 #3 I still need help --> Update Query I got it! I had to create another table and link it to the query. I am working from an ODBC dbf and the table is uneditable for safety purposes. Thanks! Last edited: Jan 31, 2003
I still need help --> Update Query I got it! I had to create another table and link it to the query. I am working from an ODBC dbf and the table is uneditable for safety purposes. Thanks!