Summarizing text data in an access report

[renegp55]

I am trying to create an access database to save our class evaluations...t he questionnaire has 4 questions that required attendees to write their comments about some aspects of our classes. Question is how can I create a report that will summarize all the comments made. I created a table and created 4 fields, text, to track the comments.
Can this be done w/o writing code? I am not a VBA expert, not even a beginner...

[Rabbit]

Summarize in what way? You can't add or average text. So you will have to define what you mean by summarize.

Also, you should be aware that keeping the data across 4 columns like that breaks rules of normalization and can make things harder to query in the future.

[zmbd]

I take it that what OP is after is an abstract or a consensus of thought/opinion of the answers.

Renegp55, if that is what you are after from a purely text based set of answers, then what you ask is not a possible task within Access, nor dare I say, a majority of databases. One would need an AI-Neural network with a language schema developed.

Because you cannot easily abstract people is why so many of the "opinion" surveys ask... on a scale of 1 to 10 where 1 is strongly hate...