[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