reverse coding for calculation

[Guest]

Hello,

I am creating a form that will be used to calculate scores on a
psychological test. In order to obtain an overall score, some responses need
to be reverse coded (e.g., if a person answers "1", it is changed to "4" and
vice versa; if a person answers "2", it is changed to "3" and vice versa).
Could someone assist me with developing the control for this in Access? I'm
not sure of the language to use in the expression or in what area I would
make the change. I'm used to doing this with statistical software, where
it's much easier.

Thanks.

 

[Al Camp]

ledbyrain,
If I understand correctly...
Why not use an Option Group control with 4 check boxes? You can assign
each option any numerical value, so Choice 1 (labeled as "1"), could have a
value of 4, Choice 2 could have a value of 3, 3 as 2 , and 4 as 1.