extraolivesplea
New member
- Local time
- Today, 23:13
- Joined
- Apr 17, 2005
- Messages
- 7
Here's what I'm trying to do:
Students have a form with 9 statements in - they check 3 of them. The underlying table uses yes/no for the statments. Is there a better structure perhaps? 3 of the statements are worth 1 point, 3 2 points and 3 3 points.
For each student I want to calculate their ovreall score.
Have built a solution to this in both Access and Excel & while I can get the calculation I want easy as in Excel, I prefer some of the other features of Access and think this will be the best programme in the long run.
Hope someone can help!
Thanks
Students have a form with 9 statements in - they check 3 of them. The underlying table uses yes/no for the statments. Is there a better structure perhaps? 3 of the statements are worth 1 point, 3 2 points and 3 3 points.
For each student I want to calculate their ovreall score.
Have built a solution to this in both Access and Excel & while I can get the calculation I want easy as in Excel, I prefer some of the other features of Access and think this will be the best programme in the long run.
Hope someone can help!
Thanks
