how to get count(col1), count(col2), count(sol3) with only one query

[Mario Krsnic]

Hallo everybody!
I have in a table three columns with boolean values. So I can get the number
in a column:
SELECT count(col1)
FROM tbl where col1=true

Is it possible to get count(col1), count(col2), count(sol3) with only one
query? In every
column should be considered only true values (col1=true, col2=true,
col3=true)
Thanks for your ideas!
Mario

 

[Allen Browne]

If these are yes/no fields, sum them.

Access uses -1 for True, and 0 for False.
The sum is therefore the count if you ignore the sign.

This kind of thing:
SELECT -Sum(Col1) AS SumOfCol1, -Sum(Col2) AS SumOfCol2,
FROM tbl;

 

[Mario Krsnic]

Thank you Allen,
the idea is so simple but great!
Mario