I am creating a psychology testing/reporting database and am having a small problem with one of the tests. This particular one if the individual answers the question with a one it is awarded 100 pts, 2=75, 3=50, 4=25 and 5=0. I have been trying to select the field as a calculated field and using the following expression:
IIf([sf36Q1]="1", 100,IIf([sf36Q1]="2", 75,IIf([sf36Q1]=31", 50,IIf([sf36Q1]="4", 25,IIf([sf36Q1]="5", 0)))))
Not having much luck with this one, any advise for a beginner?