use query or form

[Dale]

I am running into problems with the best way to design a form. I created a
query that shows a listing of providers, the questionid, and the response to
the answer. In otherwords it looks something like this:

[agencyname] [questionid] [response]
provider1 1 1
provider2 1 3
provider2 1 1
provider2 3 2
provider3 3 1
provider3 2 2

Agencyname=the name of the agency
questionid=the number representing the question number
the response= 1=y, 2=n, 3=na

I want to create a form that will list in a format with the provider on the
left and out to the right it will list how many Y, N, and NA for question 1
and list the total% of questions answered yes from the Y, N, NA group of
question1, how many Y, N, NA for question 2 and %, how many Y, No, NA for
question3, etc. So the form will be formatted to look like this:

question1 quest.2 quest3
Y N NA %yes Y N NA %yes Y N NA%yes
--------------------------------------------------------------
Prov1 1 0 0 100% 0 0 0 0% 0 0 0 0%
Prov2 1 0 1 33% 0 0 0 0% 0 1 0 0%
Prov3 0 0 0 0 0 1 0 0 % 1 0 0 100%

and so on.

I am not sure how exactly I need to do this. Do I need to create several
querys each representing the number of yes for question1, another for the
number of no for question1, the number of na for question1. I can do that if
I need to but I would think there is a way to do all of the calculations in
the form but I can't figure out how to get each field to represent just the
response for a particular question. Any ideas of what direction I need to
take?

Thanks,
Dale