Hi - I'm reposting this ( thanks Ken ) .. I can't reproduce my original post exactly but the first coupla lines were about me being a newbie to vba and pathetically grateful for any help :-)
That said : here's my problem. Readers are given tests at periodical intervals with each test consisting of 5 questions - each question having 5 possible answers ranging from 0 to 1. The problem I'm facing is with scoring this. It's not a straight scoring where I just add the values from q1 to q5.
In this case, to calculate the total score, I have to use the formula ( total score * no of questions) / num of questions answered. It's also important to keep track of which questions were answered because each question is scored differently. For e.g if a reader enters a value of 3 for question 1, then the actual score is 4-3 = 1 and so on...
Of course, the above scenario is an oversimplified version of my original db : in actuality, there's about 40 questions in each test..
I'm attaching a sample db - the test table has the date as pk [ this won't work in a real world scenario but for now it should do ]
Once again, thanks for your time
JK