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

  • Thread starter Thread starter labelladonna
  • Start date Start date
L

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!
 
I would use a subreport based on a totals query like:

SELECT [AnswerField], Count(*) as NumOf
FROM tblNoNameGiven
GROUP BY [AnswerField];
 
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?
 
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


labelladonna said:
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?

labelladonna said:
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!
Click to expand...
Click to expand...
 
Back
Top