How do I return only selected fields for a record?

[Guest]

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?

 

[RipperT]

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

HTH