[thelist] SQL: counting rows in access SOLVED

Anthony Johnston . Antix tech at antix.co.uk
Thu Oct 3 10:40:01 CDT 2002


you talking to yourself is the first sign of programming :)

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Jon Steele
Sent: 03 October 2002 16:36
To: thelist at lists.evolt.org
Subject: RE: [thelist] SQL: counting rows in access SOLVED


I am idiot. Tried 'group by' and it worked :p.

regards..jon

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Jon Steele
> Sent: October 3, 2002 9:17 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] SQL: counting rows in access
>
>
> 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.
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
>
>
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !



More information about the thelist mailing list