Reverse Coding

fuel52

New member
Local time
Today, 05:26
Joined
Jul 16, 2003
Messages
9
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?
 
What? Explain this again, it doesnt seem to make sense...
 
In the simplest terms...

Drop down box on form, choose 1, 2, 3 or 4

On a couple of items they need to be reverse coded. So, if they choose 1, it needs to be entered as 4 in the database.
 
Add another column to the table that has these. And add the backwards number you want with it I guess. Psychological test thats backwards, that makes sense.....
 
Fuel,

Use the AfterUpdate event of the combo box to put a Case statement
based on the current value of the DropDown:

Code:
Select Case Me.YourCombo
   Case 1
      Me.YourCombo = 4
   Case 2
      Me.YourCombo = 3
   End Select

Wayne
 
But wouldnt that display the cbo now having 4 instead of 1 as an example.
 
Obviously your tables are not normalized or this would affect all questions. To make this work you would need to use an unbound combo box. You will need to "convert" the data twice. Once in the onCurrent event to populate the combo and again in the combo's AfterUpdate event to store the correct value.

I would recommend rewording the question so you don't need to do this.
 

Users who are viewing this thread

Back
Top Bottom