Tallying selections from adrop-down box

L

L. Edwards

I am trying to creat a report or query that will tally the results from a
drop down box. my database allows my employees to inform me of the outcome of
a phone call placed. There are 8 different possible outcomes to a phone call
in the drop down list. I want to be able to calculate how many of each
outcome was selected in the whole list. I can have the outcomes displayed
either as a number or text in the table.

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

I want to be able to calculate the number of "No Answer" I get in the list
or "Wrong Number" etc. Now, I know that I can have the results appear in the
table in numerical form or text form but either way it means the same thing.
I have not been able to figure out how to accomplish this or even if its
something that can be accomplished. Please let me know if this is doable.
 
G

Graham Mandeno

This is done with a "GROUP BY" (or "aggregate") query.

In its simplest form, create a new query and add your table containing the
call outcomes. Click on the Greek "sigma" (Totals) button on the query
design toolbar. Add the CallOutcome field to your query, then add it again,
so it appears in the first two columns. Leave the "Totals" cell in the
first column as "Group by" but change the second one to "Sum". Then run the
query. You should see something like this:

Answered 56
Disconnected 2
Left Voicemail 10
No Answer 8
Wrong Number 3
 
L

L. Edwards

Thank you! that worked great!

Now I have another question.
Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query information?

And is it possible to tally results from more than one table list on the
same Group By query?
--
L. Edwards


Graham Mandeno said:
This is done with a "GROUP BY" (or "aggregate") query.

In its simplest form, create a new query and add your table containing the
call outcomes. Click on the Greek "sigma" (Totals) button on the query
design toolbar. Add the CallOutcome field to your query, then add it again,
so it appears in the first two columns. Leave the "Totals" cell in the
first column as "Group by" but change the second one to "Sum". Then run the
query. You should see something like this:

Answered 56
Disconnected 2
Left Voicemail 10
No Answer 8
Wrong Number 3

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
I am trying to creat a report or query that will tally the results from a
drop down box. my database allows my employees to inform me of the outcome
of
a phone call placed. There are 8 different possible outcomes to a phone
call
in the drop down list. I want to be able to calculate how many of each
outcome was selected in the whole list. I can have the outcomes displayed
either as a number or text in the table.

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

I want to be able to calculate the number of "No Answer" I get in the list
or "Wrong Number" etc. Now, I know that I can have the results appear in
the
table in numerical form or text form but either way it means the same
thing.
I have not been able to figure out how to accomplish this or even if its
something that can be accomplished. Please let me know if this is doable.
 
G

Graham Mandeno

Yes. Click on the button to create a new report, select the query you have
created in the dropdown list, click on "Chart Wizard" and follow your nose.
--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
Thank you! that worked great!

Now I have another question.
Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query
information?

And is it possible to tally results from more than one table list on the
same Group By query?
--
L. Edwards


Graham Mandeno said:
This is done with a "GROUP BY" (or "aggregate") query.

In its simplest form, create a new query and add your table containing
the
call outcomes. Click on the Greek "sigma" (Totals) button on the query
design toolbar. Add the CallOutcome field to your query, then add it
again,
so it appears in the first two columns. Leave the "Totals" cell in the
first column as "Group by" but change the second one to "Sum". Then run
the
query. You should see something like this:

Answered 56
Disconnected 2
Left Voicemail 10
No Answer 8
Wrong Number 3

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
I am trying to creat a report or query that will tally the results from
a
drop down box. my database allows my employees to inform me of the
outcome
of
a phone call placed. There are 8 different possible outcomes to a phone
call
in the drop down list. I want to be able to calculate how many of each
outcome was selected in the whole list. I can have the outcomes
displayed
either as a number or text in the table.

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

I want to be able to calculate the number of "No Answer" I get in the
list
or "Wrong Number" etc. Now, I know that I can have the results appear
in
the
table in numerical form or text form but either way it means the same
thing.
I have not been able to figure out how to accomplish this or even if
its
something that can be accomplished. Please let me know if this is
doable.
 
L

L. Edwards

I am still having trouble creating the chart from the query. the information
in the chart is not displaying the results of the totals from the Group By
query. The chart just displays 1 color and 100% instead of a seperated
percentage pie chart like the sample that is displayed in Design View. When I
go into Chart options it will not allow me to indicate the Series I want to
use in the chart.
Help Please!
--
L. Edwards


Graham Mandeno said:
Yes. Click on the button to create a new report, select the query you have
created in the dropdown list, click on "Chart Wizard" and follow your nose.
--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
Thank you! that worked great!

Now I have another question.
Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query
information?

And is it possible to tally results from more than one table list on the
same Group By query?
--
L. Edwards


Graham Mandeno said:
This is done with a "GROUP BY" (or "aggregate") query.

In its simplest form, create a new query and add your table containing
the
call outcomes. Click on the Greek "sigma" (Totals) button on the query
design toolbar. Add the CallOutcome field to your query, then add it
again,
so it appears in the first two columns. Leave the "Totals" cell in the
first column as "Group by" but change the second one to "Sum". Then run
the
query. You should see something like this:

Answered 56
Disconnected 2
Left Voicemail 10
No Answer 8
Wrong Number 3

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

I am trying to creat a report or query that will tally the results from
a
drop down box. my database allows my employees to inform me of the
outcome
of
a phone call placed. There are 8 different possible outcomes to a phone
call
in the drop down list. I want to be able to calculate how many of each
outcome was selected in the whole list. I can have the outcomes
displayed
either as a number or text in the table.

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

I want to be able to calculate the number of "No Answer" I get in the
list
or "Wrong Number" etc. Now, I know that I can have the results appear
in
the
table in numerical form or text form but either way it means the same
thing.
I have not been able to figure out how to accomplish this or even if
its
something that can be accomplished. Please let me know if this is
doable.
 
G

Graham Mandeno

I'm afraid I'm not much of an expert on Access graphs, because I usually do
this through Excel automation. I suggest you post your question in a new
thread, mentioning specifically the graph problem.
--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
I am still having trouble creating the chart from the query. the
information
in the chart is not displaying the results of the totals from the Group By
query. The chart just displays 1 color and 100% instead of a seperated
percentage pie chart like the sample that is displayed in Design View.
When I
go into Chart options it will not allow me to indicate the Series I want
to
use in the chart.
Help Please!
--
L. Edwards


Graham Mandeno said:
Yes. Click on the button to create a new report, select the query you
have
created in the dropdown list, click on "Chart Wizard" and follow your
nose.
--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

L. Edwards said:
Thank you! that worked great!

Now I have another question.
Is it possible when creating a report that includes the results of this
query, to also create a pie chart or bar graph using the query
information?

And is it possible to tally results from more than one table list on
the
same Group By query?
--
L. Edwards


:

This is done with a "GROUP BY" (or "aggregate") query.

In its simplest form, create a new query and add your table containing
the
call outcomes. Click on the Greek "sigma" (Totals) button on the
query
design toolbar. Add the CallOutcome field to your query, then add it
again,
so it appears in the first two columns. Leave the "Totals" cell in
the
first column as "Group by" but change the second one to "Sum". Then
run
the
query. You should see something like this:

Answered 56
Disconnected 2
Left Voicemail 10
No Answer 8
Wrong Number 3

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

I am trying to creat a report or query that will tally the results
from
a
drop down box. my database allows my employees to inform me of the
outcome
of
a phone call placed. There are 8 different possible outcomes to a
phone
call
in the drop down list. I want to be able to calculate how many of
each
outcome was selected in the whole list. I can have the outcomes
displayed
either as a number or text in the table.

For Example:

Name ID Phone Call Outcome
Jane Doe ****** (999) 555-1234 No Answer
John Doe ****** (999) 555-2345 Left Voicemail
Jana Doe ****** (999) 555-3456 Wrong Number
Josh Deo ****** (999) 555-5467 Disconnected

I want to be able to calculate the number of "No Answer" I get in
the
list
or "Wrong Number" etc. Now, I know that I can have the results
appear
in
the
table in numerical form or text form but either way it means the
same
thing.
I have not been able to figure out how to accomplish this or even if
its
something that can be accomplished. Please let me know if this is
doable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top