True or false

[tleec]

I have a table that has a multitude of check boxes (the default value is TRUE), how would I set up a query that will let me view only the records where one or more of the values= false

[iandarkwater]

True has a 'value' of -1 & false 0

So if you have 100 checkboxes defaulted to True then

Abs(Checkbox1+checkbox2....................+Checkb ox100) = 100

so you would use

Abs(Checkbox1+checkbox2....................+Checkb ox100) < 100

as a criteria.

Best of Luck

Ian