I am using this variable assignment in MSAccess97 to convert a code
reference to it's string meaning using the IIf function.
Access doesn't like it, and wont run.
Is it because it is too long, or is something wrong?
Is there a better or more simple way of acheiving the same thing?
Here is the criteria, using the IIf function...

CallNum:IIf ([priority]='1','System Down',"& " IIf([priority]='2','Urgent
Response Required', "&" IIf([priority]='3','Standard Response Required', "
& " IIf([priority]='4','Advice Required', "&" IIF([priority]='5','Call
Dealt With By Desk', "&" IIf([priority]='6','Suspended Call', ''))))))

Thanks for any help offered.