Newbie HELP....Counting different responses in a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Newbie user here. I am looking for a way to count 3 different results in the same field of a table. The row source for this field is a field list from another tabel.

All but two fields in my table are number fields which I am averaging for reporting but I need a count on question 2 and 1 other question which is a yes & no question, I think I have found the way to due this, but I will determin that later

I am trying to determine how many of customers call our corporat HQ (lexington) and how many call our Regional offices(Regional) , and how many call both (Both) regularly.
Below is an example of my table

tblquestionnair

question1 question 2 question
10 Lexington
9 Regional
3 Both
4 Lexington 1

Any help would be greatly appreciated.
 
HI,


Tentatively, since I am far from being sure of what your data really
represents, I would say:


SELECT Question2,COUNT(*)
FROM tblQuestionnaire
GROUP BY Question2



or, if you prefer, open a new query, on the table, then, click on the
summation button on the toolbar, a new line, total, appear in the grid. Drag
the field Question2 in the grid, keep the proposed GROUP BY. Drag it again a
second time, this time change the Group By to COUNT. That's all, if I
understand well.


Hoping it may help,
Vanderghast, Access MVP


Barry said:
Newbie user here. I am looking for a way to count 3 different results in
Click to expand...
the same field of a table. The row source for this field is a field list
from another tabel.
All but two fields in my table are number fields which I am averaging for
Click to expand...
reporting but I need a count on question 2 and 1 other question which is a
yes & no question, I think I have found the way to due this, but I will
determin that later.
I am trying to determine how many of customers call our corporat HQ
Click to expand...
(lexington) and how many call our Regional offices(Regional) , and how many
call both (Both) regularly.
 
Thanks Michael,

Basically I am trying to count the total number of each answer from question 2, 3 choices ( Lexington, Both, & Regional). In other words how many "lexington", "Both" and "regional" in total. This represents who are customers call to place orders, The regional office, HQ (lexington) or Both regional and HQ.

I will try the code you sent and see if I can figure anymore out with it. Thanks for the help, any other advice is greatly appreciated.

Barry

----- Michel Walsh wrote: -----

HI,


Tentatively, since I am far from being sure of what your data really
represents, I would say:


SELECT Question2,COUNT(*)
FROM tblQuestionnaire
GROUP BY Question2



or, if you prefer, open a new query, on the table, then, click on the
summation button on the toolbar, a new line, total, appear in the grid. Drag
the field Question2 in the grid, keep the proposed GROUP BY. Drag it again a
second time, this time change the Group By to COUNT. That's all, if I
understand well.


Hoping it may help,
Vanderghast, Access MVP


Barry said:
Newbie user here. I am looking for a way to count 3 different results in
Click to expand...
the same field of a table. The row source for this field is a field list
from another tabel.reporting but I need a count on question 2 and 1 other question which is a
yes & no question, I think I have found the way to due this, but I will
determin that later.(lexington) and how many call our Regional offices(Regional) , and how many
call both (Both) regularly.
 
Back
Top