How do I return only selected fields for a record?

H

howbe

I have a Table that allows you to select several "yes/no" option boxes for
different fields. How can I make is so only the Fields that have a "yes"
selected will show up in a Query?
 
R

RipperT

SELECT myTable.myField1, myTable.myField2, myTable.myCheckbox1,
myTable.mycheckbox2
FROM myTable
WHERE (myTable.myCheckbox1 = True) OR (myTable.MyCheckbox2 = True);

HTH
 
Top