Looking for the right query video.
I have a table named quiz and on the table the are fields named quizname, qiuznumber, ch1, ch2, ch3 ch4, many more.
I would like to create a query loading quiz number and ch1 or ch2 only using a combobox called cboselectch

for example if cboselectch = ch2 the the query loads quiz and ch2 fields only
            if cboselectch = ch3 the the query loads quiz and ch3 fields only

I know you have a vid on it just cant find it

I have tried SELECT QUIZ.quizname, QUIZ.cboselectch
FROM QUIZ