I have a query containing values and the (15) columns are labelled A - O representing multichoice exam question options. When an exam is run, a varying quantity of candidates pick options so I end up with something resembling the following:
QuestionID A B C D E......O
12345 2 10 2 5 7.....
What I want to do is find the largest value, in this case 10, then compare it to the correct answer value, this is in a different query and return a statement "Possible Wrong Answer (PWA)"
I have attached an exported version of query into excel and highlighted items to show how the comparison should work.