I have two check boxes on the same table and I want to run an update query that will look for both checks per line and then remove them. If they are both not present either one will stay checked.
If you do this in the query design window, drag the two checkbox fields to the bottom panel. Set the criteria for both to be True on the same criteria row.
In the "Update To" cell, enter the keyword False.
View the query in Datasheet mode to see what you'll be updating and then run it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.