[thelist] SQL: counting rows in access

Jon Steele jsteele at globalmss.com
Thu Oct 3 08:15:00 CDT 2002


Thanks Anthony...i totally blanked out on using sum...:p

Now I've hit another snag. I have a group field as well for each row...

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

There are only three. How can i group the sums based on the groups...

----------------------------------------------------
Group | sun | mon | tues | wed | thur | fri | sat |
----------------------------------------------------
A       45     43    23     80    46    14     84
B       65     13    22     80    13    34     49
C       25     23    73     30    33    23     54

So that the number of trues for each day for group A are on one row, B on
the next, etc.

cheers

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Anthony Johnston .
> Antix
> Sent: October 3, 2002 8:42 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] SQL: counting rows in access
>
>
> use select sum(mon), sum(tues) from table
>
> cheers Ant.




More information about the thelist mailing list