update a field in all records

  • Thread starter Thread starter Troy
  • Start date Start date
T

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.
 
Open a new query window, switch it to SQL view, and paste in the following
line:
UPDATE [NameOfYourTable] SET [NameOfYesNoField] = 0
 
Troy said:
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.
Click to expand...

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

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