This is my first post to this forum...I'm hoping someone will be able to help, as I have next to no experience with SQL programming.....

I've created a database to help analyze responses from various questionnaires. The tables I have include questions, responses and users. The "questions" table lists a given question four times, with one of four potential responses for each record. For example:
Question: Do you feel the sky is blue Response1: Yes, I do
Question: Do you feel the sky is blue Response2: No, definitely not
Question: Do you feel the sky is blue Response3: I am not sure
Question: Do you feel the sky is blue Response4: Maybe, I haven't checked

These have been combined into a query. From this query I created a report that groups questions, then responses, counts the # of responses for each question and calculates what percentage of users answered each of the four potential ways. For example for question 1, 3 people responded "yes" (response1)(representing 66% of total responses for that question, and 1 responded "I am not sure" (response3)(representing 33% of total responses for that question). The grouping feature is very important in these calculations. How do I recreate these same report-based calculations in a query (or refer to the existing calculations in the report) so that I can base other queries on them? I will want to show responses from one company in particular, and compare those responses to % of how all other respondants answered.

Thank you in advance...