Update an entire table with sql

[DDTiff]

Can anyone tell me how to update a table in MS Access DB using sql? Thank you very much for your time.


Diem

 

[THoey]

UPDATE MyTable
SET MyTable.MyField = "ABC"
WHERE MyTable.MyField = "XYZ";

If that doesn't answer your question, please be more explicit... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...