My suggestion would be to not have this set up so that this is "several fields in one record". Each response should be in a separate record of a related table of responses with fields that link each record to a specific respondant and a specific question.
Here's a link to a thread on Survey or questionaire databases: Need aid on generating a report from a survey layout.
Thank you for your feedback. This questionnaire is part of a larger database. It was suggestd previously, that i break down various components and work on them and the integrate them via relationships. I have been able to resolve the summing of several fields as a subtotal by using case and let statements. It has taken trial and error. Your thread will be very useful for another aspect of the database. Your time is greatly appreciated