Replacing Checkbox Value

N

Nighthawk

Is there a way to globally replace a "yes" or "true" selection in a checkbox
(Yes/No) field in a table with the opposite? In other words, globally check
or uncheck boxes in a field.

As a workaround, I tried putting in "-1" as the default value for a checkbox
field, instead of "0", but that didn't work.
 
K

Klatuu

Yes, you can reverse them using an update query.
In the Update To of the field:

Not [FieldName]
 
Top