borgkling2003
MIS
I got a database that looks like this
ID|Q1|Q2|Q3|Q4
---------------
11|A|A|C|B
13|C|C|C|A
Q1 to Q4 contains the answer of a multiple choice question
I need to a query that can return the average answer in the for below eg
ID|Average
----------
11|A
12|C
Can anyone help?
ID|Q1|Q2|Q3|Q4
---------------
11|A|A|C|B
13|C|C|C|A
Q1 to Q4 contains the answer of a multiple choice question
I need to a query that can return the average answer in the for below eg
ID|Average
----------
11|A
12|C
Can anyone help?