scoring table

[dbertanjoli]

Hello,
My brain is currently not working and I am hoping for somebody’s help..

I have an access database that collects medical survey info (data is coming from the online form).
I have 3 tables:
Tblquestions
Tblpeople
Tblanswers

There are 30 questions and each question has mostly 5 choices (radio button group). When we receive a survey we would like to attach scoring to each answer. So I am having troubles with my answer table. I have three fields in it:
questionnumber (very important as scoring of answer depends on the question, for example, moderate in question one can be worth 2 points and in question 5 four points)
questionscore
questiondescription.

I can’t figure it out how to properly do this so that I can in my query see the scoring of each answer?

Your help is very much appreciated.

Deb

 

[georgedwilkinson]

This is so incredibly similar to another current post that it makes me think you are both working on the same assignment.

See Craig's detailed answer here:
http://www.access-programmers.co.uk/forums/showthread.php?t=147602

 

[dbertanjoli]

Hello,
I just browsed through the answers but couldn't relate my problem. I have a web based form and I am just receiving answer into my database. I need to have a scoring table that can relate to each answer. What I did, and it is wrong, I put together answer and score (same field) and then I split them up in query (I know it is wrong ). Please see attached database and let me know if you could help me have a result table that I can query properly?
Many thanks,
Debbie

 

[dbertanjoli]

I would greatly appreciate anybody's reply. I am under a deadline and I tried everything I know.

Many thanks,
Deb

 

[georgedwilkinson]

Deb, I'd really like to help but I have several contracts I'm working on at the moment.

I scanned the link I sent you earlier (http://www.access-programmers.co.uk/forums/showthread.php?t=147602) and CraigDolphin's reply on 4-16-2008 at 2:11 PM seems to answer your question. I cannot make it any plainer than that. The only thing I would do differently is drop the "tbl" from the beginning of the table names. Craig has basically designed your system for you.

Sorry I cannot do more right now. Maybe the middle of next week I'll have more time.