extraolivesplea
New member
- Local time
- Today, 22:24
- Joined
- Apr 17, 2005
- Messages
- 7
Hi!
Here's want I'm doing:
Creating a form for students to fill in - list box to select name, then yes/no boxes for them to select 3 relevant statements out of 9. 3 statements are worth 1 poiint, 3 worth 2 points and 3 woth 3 points.
What I want to be able to do is calculate their points on the basis of their statement selection and then return a comment based on their total.
Easy in Excel but how do you do it in Access?!!!
Want to use Access rather than Excel because has many otrher functions I want to use.
Thanks
Here's want I'm doing:
Creating a form for students to fill in - list box to select name, then yes/no boxes for them to select 3 relevant statements out of 9. 3 statements are worth 1 poiint, 3 worth 2 points and 3 woth 3 points.
What I want to be able to do is calculate their points on the basis of their statement selection and then return a comment based on their total.
Easy in Excel but how do you do it in Access?!!!
Want to use Access rather than Excel because has many otrher functions I want to use.
Thanks