I have a table that has a bunch of check box fields. I want to be able to query for any records that DO NOT have all check boxes checked. Any suggestions?
I figured out what I needed to do. It's along the order of +/-18 check box fields. I was doing the query in design view and decided to look at the SQL view. There I saw that I could change the "AND" to "OR" and have it work like I wanted.
I guess I was confused by your conflicting Query for any "False" item in record
title and I want to be able to query for any records that DO NOT have all check boxes checked
first post....
You can more easily do this by adding the Checkbox fields together and setting the criteria to >-11 (if there are 11 checkboxes). Then only one comparison is done. For example:
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.