Report chart SELECT COUNT WHERE

hi im building an asp page where i want a Visual Studio Report Controls
with a chart that shoes the count of some data in a table that i have. in that table i have some ids , names, and questions.
ID (int)
Name (Varchar)
Q1 (nchar)
Q2 (nchar)
etc...
the values in the questions fields r only:
YES
NO
N/A
i need the chart to show me How many Yes, No, N/a per Question
anny ideas how i make this work???
please anny help is welcomme

im still stuck here!
tryed severall diferent ways
can please someone help??
preaty please :o :o :o

guys! still need help in this one!
no ideas?
i search, googled it and still nothing!
please help

Isnt a query like this one work?

Code:

---

SELECT    Id, Operador, Month, Flight, Date, UH, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9
FROM        LOAD_CONTROL
WHERE    (Operador = @Op) OR
                      (Date BETWEEN @In AND @End) OR
                      (UH = @UH) THEN
                          SELECT    'Q1' AS Q, Q1 AS YesNo, COUNT(*) AS QCount
                          FROM        LOAD_CONTROL AS LOAD_CONTROL_1
                          WHERE    (Q1 IN ('Yes', 'No', 'N/A'))
                          GROUP BY Q1
UNION ALL
SELECT    'Q2' AS Q, Q2 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_2
WHERE    (Q2 IN ('Yes', 'No', 'N/A'))
GROUP BY Q2
UNION ALL
SELECT    'Q3' AS Q, Q3 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_3
WHERE    (Q3 IN ('Yes', 'No', 'N/A'))
GROUP BY Q3
UNION ALL
SELECT    'Q4' AS Q, Q4 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_4
WHERE    (Q4 IN ('Yes', 'No', 'N/A'))
GROUP BY Q4
UNION ALL
SELECT    'Q5' AS Q, Q5 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_5
WHERE    (Q5 IN ('Yes', 'No', 'N/A'))
GROUP BY Q5
UNION ALL
SELECT    'Q6' AS Q, Q6 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_6
WHERE    (Q6 IN ('Yes', 'No', 'N/A'))
GROUP BY Q6
UNION ALL
SELECT    'Q7' AS Q, Q7 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_7
WHERE    (Q7 IN ('Yes', 'No', 'N/A'))
GROUP BY Q7
UNION ALL
SELECT    'Q8' AS Q, Q8 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_8
WHERE    (Q8 IN ('Yes', 'No', 'N/A'))
GROUP BY Q8
UNION ALL
SELECT    'Q9' AS Q, Q9 AS YesNo, COUNT(*) AS QCount
FROM        LOAD_CONTROL AS LOAD_CONTROL_9
WHERE    (Q9 IN ('Yes', 'No', 'N/A'))
GROUP BY Q9

---

if so what is wrong???
PLEASE HELP
THANKS IN ADVANCE