SQL UPDATE help needed

[Zaeed]

I have a table that has a autonumber ID field, and then multiple fields which are all yes/no checkboxes.

Can somebody show me a way of performing an SQL UPDATE that will uncheck all the fields, hopefully without having to manually typing in each field name.

 

[Zaeed]

If you want to update all the columns, create a query with all the columns and specify the update value for each column.

my question was is there another way.

My table is setup like this since it is the easiest way to handle the information its storing.

 

[Jon K]

Pat has pointed you in the right direction.

Just do it in the update query Design View. You don't need to type any field names. All you need to type is the word False in the Update To: row for each field.

If you need the SQL statement, after creating the update query in Design View, you can switch the query to SQL View and copy the statement from there.
.