How do I count more than one column with a where clause? (SQL)

[leadustin]

I have the following query: \[code\] SELECT count(Committees) FROM [Annual Questionnaire] WHERE Committees=TRUE;\[/code\]However, I'd like to include other columns in the result e.g. Insurance, Equalities and counted where the value is True e.g. Insurance=True. Not all the columns in the table have to be counted. I think a pseudo query would be: \[code\]SELECT count(Committees), count(Insurance)FROM [Annual Questionnaire]WHERE Committees=TRUE AND Insurance=TRUE;\[/code\]^ This doesn't work because it selects rows where only Committees and Insurance is True Basically, how do I count the specified columns where the value is True?