Hi, everyone.

 I'm having a bit of trouble trying to construct an SQL query. What I want
the query to do is count the number of times a call was made by a certain
person. The query pulls from a table called tblCompanies and from a field
named "calledby".

  I want the query to display a listing of the names in the calledby field
and how many times that name appears. I tried constructing a count query
like this:

select count(calledby) as Count where calledby='name'

  But that didn't work because I'd have to have 20 different recordsets to
get the information I want. I'm sure somebody has a good way to do this. Any
help is appreciated and details are always good.

Thanks in advance!

--Ashley

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

SELECT
    CalledBy,
    COUNT(CalledBy)
FROM
    YourTableNameHere
GROUP BY
    CalledBy

will output something like:

John Smith            20
Jane Doe               17
Person Three         42
...
Person n                19

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Young, Ashley" <Ashley.Young@c...>
Subject: [access_asp] SQL Query Difficulty


: Hi, everyone.
:
:  I'm having a bit of trouble trying to construct an SQL query. What I want
: the query to do is count the number of times a call was made by a certain
: person. The query pulls from a table called tblCompanies and from a field
: named "calledby".
:
:   I want the query to display a listing of the names in the calledby field
: and how many times that name appears. I tried constructing a count query
: like this:
:
: select count(calledby) as Count where calledby='name'
:
:   But that didn't work because I'd have to have 20 different recordsets to
: get the information I want. I'm sure somebody has a good way to do this.
Any
: help is appreciated and details are always good.
:
: Thanks in advance!
:
: --Ashley
:
: ---
: Outgoing mail is certified Virus Free.
: Checked by AVG anti-virus system (http://www.grisoft.com).
: Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
:
:

Ashley,

Try this...

SELECT calledby, Count(calledby) AS Count
FROM tablename GROUP BY calledby

Larry Woods


> -----Original Message-----
> From: Young, Ashley [mailto:Ashley.Young@c...]
> Sent: Wednesday, October 23, 2002 1:27 PM
> To: Access ASP
> Subject: [access_asp] SQL Query Difficulty
>
>
> Hi, everyone.
>
>  I'm having a bit of trouble trying to construct an
> SQL query. What I want
> the query to do is count the number of times a call
> was made by a certain
> person. The query pulls from a table called
> tblCompanies and from a field
> named "calledby".
>
>   I want the query to display a listing of the names
> in the calledby field
> and how many times that name appears. I tried
> constructing a count query
> like this:
>
> select count(calledby) as Count where calledby='name'
>
>   But that didn't work because I'd have to have 20
> different recordsets to
> get the information I want. I'm sure somebody has a
> good way to do this. Any
> help is appreciated and details are always good.
>
> Thanks in advance!
>
> --Ashley
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date:
> 7/15/2002
>
>