Reverse Coding

[fuel52]

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?

 

[sonny]

What? Explain this again, it doesnt seem to make sense...

 

[fuel52]

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.

 

[sonny]

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.....

 

[WayneRyan]

Fuel,

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

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

Wayne

 

[sonny]

But wouldnt that display the cbo now having 4 instead of 1 as an example.