IIF STATEMENT WON'T WORK 1

[nomi1]

I am trying to insert an "IIF" statment into a field and each time I do it gives me the messaage that an identifier is needed. My IIF statement is as follows:

=IIF([MASTER.TOTAL HRS EARNED]>90,"SENIOR",IIF([MASTER.TOTAL HRS EARNED]>60,"JUNIOR",IIF([MASTER.TOTAL HRS EARNED]>30,"SOPHOMORE",IIF([MASTER.TOTAL HRS EARNED]>0,"FRESHMAN","value missing"))))

Can someone please tell me what I am doing wrong?

Naomi

 

[TonyMcGuire]

What is the '=' at the beginning? Shouldn't be there, I don't believe.


Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.