Question & Mulitple Choice answers database

[Ray]

I just have a brief idea of this approach and would like to hear a few words
from experts here. I have medium level of programming in Access. In fact,
I would like to build a simple database to replace a spreadsheet showing the
scores of the suppliers. Initially, I need to build a form like multiple
choice Q & A sheet for the judges to input the scores and then generate a
report showing the score of each element and total score like the hard copy
of the spreadsheet. I am unsure if this is a right direction so I need
guidance from the experience people.

Thanks,

Ray

[Tom van Stiphout]

On Tue, 2 Dec 2003 18:23:21 +0800, "Ray" <ra****@usa.com> wrote:

What problem are you trying to solve with the migration to Access?
-Tom.

I just have a brief idea of this approach and would like to hear a few words
from experts here. I have medium level of programming in Access. In fact,
I would like to build a simple database to replace a spreadsheet showing the
scores of the suppliers. Initially, I need to build a form like multiple
choice Q & A sheet for the judges to input the scores and then generate a
report showing the score of each element and total score like the hard copy
of the spreadsheet. I am unsure if this is a right direction so I need
guidance from the experience people.

Thanks,

Ray

[Pieter Linden]

"Ray" <ra****@usa.com> wrote in message news:<bq**********@news.hgc.com.hk>...

I just have a brief idea of this approach and would like to hear a few words
from experts here. I have medium level of programming in Access. In fact,
I would like to build a simple database to replace a spreadsheet showing the
scores of the suppliers. Initially, I need to build a form like multiple
choice Q & A sheet for the judges to input the scores and then generate a
report showing the score of each element and total score like the hard copy
of the spreadsheet. I am unsure if this is a right direction so I need
guidance from the experience people.

Thanks,

Ray

Keri Hardwick answered this really well a few years ago. Look up
"Survey" in this NG. You would just need to do something like have a
table of correct answers and then compare using a query. (Join on
QuestionID) and then something like:

IIF([AnswerTable].[Answer]=[Respondent].[Answer],1,0) *
AnswerTable.[QuestionWeight],0)

You could base your report on this and then do a total over reach
record...