Counting?

[Dave Q]

I have a table called CallLog. This table has columns
Call Date, Office Code, Call Type. I need the query to
break the information down by office code and date,
Office Code and then what Call Types that were taken. I
have separate tables for the office codes and the call
types. I want it to list all the call types and they
respond with the number of calls for that type. I need it
to look something like this:

Date Office Code Call type Number of calls
2/22/04 32 Sale 3
ONR 2
PND 5
33 Sale 6
ONR 5
PND 5
2/27/04 32 Sale 6
ONR 1
PND 3
33 Sale 2
ONR 9
PND 17

I have tried some other suggestions that have been posted
for other people, but have not been able to get any of
them to work. It may be due to my limited expierence in
Access.

Thank You

 

[Duane Hookom]

It's not good practice to start a new thread since we don't know what was
suggested previously and don't want to make the same suggestions as given
previously and didn't seem to work for you.

What have you tried and how didn't it work?

 

[DaveQ]

This is one thing I did try. I will foreward the other in
another posting.I appreciate your help.


Subject: Re: Query Help
Sent: 3/2/2004 1:26:43 PM

I need my query to list our offices, then list the
quantity of call types that they received.

For example:

Office Type Number of calls
Jack Sale 3
Order Prob 6
Odr not Rec 2

Phil Sale 6
Order Prob 2
Odr not Rec 1

The easier the instructions the better due to my limited
knowledge of Access.
Thank You

The instructions will be a heck of a lot easier to write
if we had
some clue about how your table is structured and where in
your table
we might be able to calculate the number of calls.

A Totals query, grouping by Office and Type, and
counting - something,
I don't know what since I can't see your table - would be
indicated.
To create one create a Query based on your table, click
the Greek
Sigma icon (looks like a sideways W), and Group By Office
and Type on
the totals line; select Count on some other field, such
as the CallID
or CallDateTime.

 

[Dave Q]

This is the second I tried. I thought these two sounded
like what I was looking for.

Thanks Again


Subject: Re: Sub count???
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 3/1/2004 10:16:48 PM




WAG to follow:
SELECT Office, CallType, Count([Call]) as NumberOfCalls
FROM tblWAG
GROUP BY Office, CallType;

--
Duane Hookom
MS Access MVP


"**Danny Johnson**" <[email protected]>
wrote in message

 

[Duane Hookom]

Paste your SQL view into a reply and tell use why they didn't work.

--
Duane Hookom
MS Access MVP

This is the second I tried. I thought these two sounded
like what I was looking for.

Thanks Again


Subject: Re: Sub count???
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 3/1/2004 10:16:48 PM




WAG to follow:
SELECT Office, CallType, Count([Call]) as NumberOfCalls
FROM tblWAG
GROUP BY Office, CallType;

--
Duane Hookom
MS Access MVP


"**Danny Johnson**" <[email protected]>
wrote in message

I am trying to get a query to work like this. I need it
to list our offices, then list the quantity of call types
that they received. For example:

Office Call type Number of calls
MLB Sale 3
Order Prob 6
Odr not Rec 2

HBK Sale 6
Order Prob 2
Odr not Rec 1

Any suggestions would be greatly appriciated.
Thank You

.


-----Original Message-----
It's not good practice to start a new thread since we don't know what was
suggested previously and don't want to make the same suggestions as given
previously and didn't seem to work for you.

What have you tried and how didn't it work?

--
Duane Hookom
MS Access MVP




.