I am trying to set up a quiz that records the answers to 7 questions. The answers for each are either a, b, c or d. After the user completes the quiz the answers are totally and the results are displayed. The results will say you entered mostly A's.... or you entered mostly B's.
The problem is I don't know how to work this out. I have set up a database to store the results but I don't know how to total up letters in the recordset.
how are the answers stored in the database for starters? you gotta provide enough information to be helped 😉
I have set up 8 fields. ID (automatically generated), q1, q2, q3, q4, q5, q6, q7.
The data that will go into each of these fields will be a, b, c or d.
I need to work out if the majority of answers are a, b, c or d
