How to add up text record in the field of a report

[labelladonna]

Hi, I am working on a report of questionnaire and answers. The answer the
respondents enter into the table that the report based on is in text:
'strongly agree', 'agree' or 'disagree'. It is only a column of 80 records.
But how may I add up the total numbers of strongly agree, agree and disagree?
Your help will be very much appreciated. Thank you!

 

[Duane Hookom]

I would use a subreport based on a totals query like:

SELECT [AnswerField], Count(*) as NumOf
FROM tblNoNameGiven
GROUP BY [AnswerField];

 

[labelladonna]

I'm ashamed that I do not yet have enough knowledge to follow the procedure
you put down. I supposed I have to create a new query in design view, then
select the table (name: survey results) and click the sumation button on the
toolbar. But than I become lost in where and how to put down the SELECT
clause. Should I do it in view SQL view? And does [AnswerField] stands or
strongly agree etc, or the field name of strongly agree etc?

 

[Duane Hookom]

Please provide your table structure and possibly a few sample records and how
they should appear in your report or report footer.
--
Duane Hookom
Microsoft Access MVP

I'm ashamed that I do not yet have enough knowledge to follow the procedure
you put down. I supposed I have to create a new query in design view, then
select the table (name: survey results) and click the sumation button on the
toolbar. But than I become lost in where and how to put down the SELECT
clause. Should I do it in view SQL view? And does [AnswerField] stands or
strongly agree etc, or the field name of strongly agree etc?

Hi, I am working on a report of questionnaire and answers. The answer the
respondents enter into the table that the report based on is in text:
'strongly agree', 'agree' or 'disagree'. It is only a column of 80 records.
But how may I add up the total numbers of strongly agree, agree and disagree?
Your help will be very much appreciated. Thank you!