Resetting

[Buffy]

Hey,
I have a field with data type 'Yes/No' in which all the records have this field set to 'Yes' i.e a ticked box. I want to be able to change all the checkboxes to a 'No' i.e. unchecked setting in one go instead of having to go through all the records and changing them manually. Is there a way to do this.
Thanks very much :D

 

[Corticus]

Sure, use an update query, like

UPDATE tbl1 SET tbl1.YesNoField = False;

Replace tbl1 with your table name, and yesnofield with the name of the yes/no field you need to update.

HTH,