option group

[GSchafer1]

I have an check box option group A:B:Cne of which is the answer to a test question. The results would be like A=0 B=1 C=2. The problem is that the values of A,B and C change on every question and there are 187 questions. The result values are then added together with other question values to compile results for specific groups. How can I do this?

Example: Question One = A:1B:0C:2 Answer is C
Question Two = A:2B:0C:1 Answer is C
Quesiton Three = A:1B:2C:0 Answer is A

Q1 and Q2 are from the same category and therefore the category total = 3

 

[llkhoutx]

One solution is to create 187 different option groups, manually setting the value of each. That's too much brute force work. Nothing more said about this method.

A relatively simple solution is to have two tables, one 4 column (ID, A, B, C) tables of "test" and one two column (ID, answer) "answer key." ID's for the two tables are related 1 to 1. ID's correspond to the questions. Grade the test by cycling though the tables with DAO/ADO code, comparing the test with the answer key, keeping track of the "score."

I'm sure someone will offer you an elegant solution.

 

[GSchafer1]

code

That makes sense. Could you give me an idea in how the code might work? I'm a bit confused when it comes to code.

 

[llkhoutx]

The attached should get you started. I think the the total must be adjusted (iScore) in my code, as you refer to a 'Category Total" and I'm not certain what that is.

Note that I've added an "Answer" field to the first table.

 

[GSchafer1]

Works fine!

llkhoutx,
Thanks very much for your assistance. I'm in over my head but I'm trying to understand. I'll be back I'm sure. Thanks for your help, I hope to finish this complex db someday soon.