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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top