I am writing an evaluation program.... the answers to the evaluation questions are saved as 2 to -2, and there are 13 questions called Opt01 to Opt13.
I need to write a query that will get the COUNT of how many 2's (or Strongly Agrees...)1's..0's...etc... that each question recieved so that i can plug that into my VB front end. Im using ADO in my VB app....
I would like to write it like this:
SELECT COUNT(Opt01) AS Opt01SA, COUNT(Opt02) AS Opt02SA.....etc
FROM EvalDetails
WHERE ???? = 2 ???
The other way would be to write 5 x 13 COUNT queries... and i can't make a script in Access that i could populate the VB ADODB.Recordset with...... or else throw 5 x 13 queries into a macro... also a pain to extract the data from....
Any help on a simpler way to get this data out... in a count.... would be greatly appreciated....
Thank You
I need to write a query that will get the COUNT of how many 2's (or Strongly Agrees...)1's..0's...etc... that each question recieved so that i can plug that into my VB front end. Im using ADO in my VB app....
I would like to write it like this:
SELECT COUNT(Opt01) AS Opt01SA, COUNT(Opt02) AS Opt02SA.....etc
FROM EvalDetails
WHERE ???? = 2 ???
The other way would be to write 5 x 13 COUNT queries... and i can't make a script in Access that i could populate the VB ADODB.Recordset with...... or else throw 5 x 13 queries into a macro... also a pain to extract the data from....
Any help on a simpler way to get this data out... in a count.... would be greatly appreciated....
Thank You
