[thelist] SQL: counting rows in access

[Jon Steele]

Hi

I have run into a problem. I am trying to do the following in Access SQL but
am now stuck. =(

I have a table with the following format:

------------------------------------------------
id | sun | mon | tues | wed | thur | fri | sat |
------------------------------------------------
1   true   true  false  true  false false false
2   false  false false  false true  true  true
3   false  true  false  false false false false
etc.
etc.

Now I need to know how many rows are true for each day...so the result set
should look like

---------------------------------------------
| sun | mon | tues | wed | thur | fri | sat |
---------------------------------------------
  45     43    23     80    43    12     4

(i.e. 45 rows have true for sun, 43 have true for mon, etc.)

Thanks in advance...any help is greatly appreciated.

Cheers,
Jon