Report chart SELECT COUNT WHERE

[Motorui]

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

[Motorui]

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

[Motorui]

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

[Motorui]

Isnt a query like this one work?

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