# [thelist] SQL: counting rows in access SOLVED

Jon Steele jsteele at globalmss.com
Thu Oct 3 10:48:05 CDT 2002

```aint it the truth bro

:o

> -----Original Message-----
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Anthony Johnston .
> Antix
> Sent: October 3, 2002 11:43 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] SQL: counting rows in access SOLVED
>
>
> you talking to yourself is the first sign of programming :)
>
> -----Original Message-----
> [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 !
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
>
>

```