Yes/No data type or Checkbox

D

donster

I would like to select a column that contains the Yes/No data type and togle
it opposite to what it currently is. There are thousands of records with
this data type. I tried selecting the column but couldn't figure out how to
toggle the checkbox. Is there an easy way for a user to do this? I want to
avoid difficult methods that the average user may feel to inadequate to do.

Thanks in for all your help!
 
T

tina

one way to "toggle" a checkbox field for multiple records in a table *all at
the same time*, is with an Update query, as

UPDATE MyTableName SET MyTableName.MyCheckboxFieldName = Not
[MyTableName].[MyCheckboxFieldName];

just open a new query, and paste the above statement into the query's SQL
view. you need to substitute the correct table and field names, of course.

hth
 
Top