Psych Testing

[CherylS]

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?

[Bob Fitz]

Perhaps:
= IIf([sf36Q1]="1", 100,IIf([sf36Q1]="2", 75,IIf([sf36Q1]="3", 50,IIf([sf36Q1]="4", 25,IIf([sf36Q1]="5", 0)))))
Or:
= IIf([sf36Q1]=1, 100,IIf([sf36Q1]=2, 75,IIf([sf36Q1]=3, 50,IIf([sf36Q1]=4, 25,IIf([sf36Q1]=5, 0)))))

[pbaldy]

Try

IIf([sf36Q1]=1, 100,IIf([sf36Q1]=2, 75,IIf([sf36Q1]=3, 50,IIf([sf36Q1]=4, 25, 0))))

[June7]

Is sf36Q1 a number or text type field?

The expression shows 31" instead of "3".

If number field, try:

Nz(Choose(Nz([sf36q1],0), 100, 75, 50, 25, 5), 0)


Otherwise:

Nz(Choose(Val(Nz([sf36q1],0)), 100, 75, 50, 25, 5), 0)

or

Nz(Switch([sf36q1]="1",100, [sf36q1]="2",75, [sf36q1]="3",50, [sf36q1]="4",25, [sf36q1]="5",5), 0)