Your question is not clear but I am giving an example. you must try if helps you. If Any one bit field is true so records can be display.
Select * from Table1 where Field1=1 or Field2=1 or Field3=1 or Field4=1 or Field5=1 or Field6=1
If you want to show data only when all bit fields are true so use this query
Select * from Table1 where Field1=1 and Field2=1 and Field3=1 and Field4=1 and Field5=1 and Field6=1