I have a table that contains 20 checkbox fields. Each checkbox
corrisponds to an Score amount.
For Example:
Checkbox1 is worth 10 points
Checkbox2 is worth 5 points
Checkbox3 is worth 2 points
Checkbox4 is worth 3 points
The report I run has these score values hard coded within the query.
For Example: IIF([Checkbox1]=Yes,10,0)
If the checkbox is checked they get 10 points. If not they get zero
points
A report is then easily generated showing how many points a person
scored on a test.
PROBLEM:
I want the user to be able to change the score values of each Checkbox.
Today Checkbox1 is worth 10 points BUT tomorrow I want to make it worth
20 points. Hardcoding the values is not an option in this case.
What would the best way to do this be? Can I create a table with these
point values in them. If so how would I link it back to the original
data holding table?
Example:
tblScore
Checkbox Score Desc Point Value
Checkbox1 Name Entered 10
Checkbox2 Paper Filled 5
Thanks for any help you can provide