I am building a database where test (psychological assessments) results are entered in a form, stored and can be pulled up in a report by each assessment to see a specific test score.
For just a few of the say 20 items on an assessment they are "reverse coded", for example, the subject has a choice of 1 to 4 in a combo box and if they enter a 1, then it's really a 4.
How do I account for this reverse coding in the database?
There's got to be a way of converting what's entered to a different number, possibly in the query going to the report (results of assessment).
Any ideas?
For just a few of the say 20 items on an assessment they are "reverse coded", for example, the subject has a choice of 1 to 4 in a combo box and if they enter a 1, then it's really a 4.
How do I account for this reverse coding in the database?
There's got to be a way of converting what's entered to a different number, possibly in the query going to the report (results of assessment).
Any ideas?