var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to count instances over multiple fields
Is there a way in SQL where you can count the number of instances over multiple fields?
I have 10 Yes/No fields and I want to have a statement that will check if there's more than 1 Yes answer on those 10 fields.
The reason why I need this is because I have another field that only gets filled in if I have more than 1 Yes.
SELECT SUM(IIf(Field1=True,1,0) + IIf(Field2=True,1,0) + ...) FROM MyTable;