update a field in all records

[Troy]

I have a table that has a checkbox field. Some of the records are checked
(yes) and some are not(no). I would like to create a query to uncheck all
of them. I would just go down the records and do it manually, but that
would take all day.

I don't know where to start as far as creating an update query. Thanks for
any input.

 

[Guest]

Open a new query window, switch it to SQL view, and paste in the following
line:
UPDATE [NameOfYourTable] SET [NameOfYesNoField] = 0

 

[Rick Brandt]

I have a table that has a checkbox field. Some of the records are checked
(yes) and some are not(no). I would like to create a query to uncheck all
of them. I would just go down the records and do it manually, but that
would take all day.

I don't know where to start as far as creating an update query. Thanks for
any input.

Put this in the SQL view of a new query then switch to design view.

UPDATE [TableName]
SET [TableName]![FieldName] = 0;