I have a Microsoft Access 2007 database with 4 forms. Each form has a question with 5 option buttons below it. A user selects an option, then hits command button “Enter”. That form closes and the next form opens. The option buttons all have point values:
Option a = 1 point
Option b = 2 points
Option c = 3 points
Option d = 4 points
Option e = 5 points
Question 1: What is your favorite sport?
So if the user selects option c they get 3 points
Again, there are 4 forms, so 4 total questions.
I would like to add up all the points from all 4 forms, then at the end say something like “you have [x] points total”.
I'm totally lost. Can this be done with a series of case statements? Is this possible since each question and option group is on a different form? Or do I need to store all the values in some table? Help!