[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