Re: counting the number of responses

You could try normalize your table structure with a union query. Then, make
a totals query based on the union query:

SELECT 1 as Question, [Q1] as Response
FROM tblQuestionniare
UNION ALL
SELECT 2, [Q2]
FROM tblQuestionnaire
UNION ALL
....;

Then create your totals query
SELECT Question, Response, Count(Response) as NumOf
FROM quniYourQuery
GROUP BY Question, Response;

--
Duane Hookom
MS Access MVP
--

"sdg8481" <sdg8481@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1644A1F-FF7D-4EB5-B74F-495D1023AE00@xxxxxxxxxxxxxxxx
> Hi,
>
> I'm not sure if this is possible but i have a table complete with
> responses
> from a questionnaire, the possible reponses are mostly as follows; Very
> Good,
> Good, Average, Bad, Very Bad. etc.....
>
> My table is set out with the unique identifier as the row header and the
> question number as each column heading and the reponse given (in text) as
> the
> value. Therefore, is there a way i can count the number of response for
> each
> question, eg.. for question 1 the number that said good, the number that
> said
> bad, etc..... and so on for about 40 questions.
>
> The only way i can think of is an individual crosstab query for every
> question, but is there another way.....
>
> Thanks in Advance


.

Relevant Pages

  • Re: Question about percents and grouping
    ... (SELECT SiteID, QuestionNum, Count(Response) ... If it is more like the first description, we can use a union query to normalize the data and then use the union query to build the query. ...
    (microsoft.public.access.queries)
  • Re: Count the no of replies.
    ... You will need separate columns for each question plus answer response. ... In the grid you will need to do the following. ... Then it would be really simple to get your data out in a Totals query (aka ... Summary Query or Aggregate query) or in a Crosstab query. ...
    (microsoft.public.access.queries)
  • Re: Query Too Complicated
    ... You really needed someting more like a table with with the questionID, the responderID, and the response. ... Since is it probably to late to restructure your table, then you are stuck with the above complicated query. ... For example with three questions you could build a UNION query that looked like the following and save it. ... Note that UNION queries cannot be built using the query grid, but must be built in the SQL view. ...
    (microsoft.public.access.queries)
  • Re: Transpose Rows to Columns in Access Query
    ... survey as an interim tool to gather succession data before we implement ERP. ... This was my first time writing a code for a union query and I believe this ... If it's JUST as you describe a Normalizing Union query will do the job. ... matter) temporary table, which I'll call tblTemp. ...
    (microsoft.public.access.queries)
  • Re: Query Question
    ... I suggested a UNION query using the function as the solution. ... Public Function fGetSection(StrIn, iSection as Integer) ... fGetSection = Null ...
    (microsoft.public.access.queries)