[Amature User]

Hi,

Below is my "iif" expression in access

=IIf([likelihood]="rare" And [Loss Given Occurrence]="Insignificant","2 & 3",iif([likelihood]="rare" and [Loss Given Occurrence]= "minor","2 & 3", iif([likelihood]="rare" and [Loss Given Occurrence]= "moderate","4 & 5", iif([likelihood]="rare" and [Loss Given Occurrence]= "major","4 & 5", iif([likelihood]="rare" and [Loss Given Occurrence]= "Catastrophic","6 & 7", iif([likelihood]="unlikely" and [Loss Given Occurrence]= "insignificant","2 & 3", iif([likelihood]="unlikely" and [Loss Given Occurrence]= "minor","4 & 5", iif([likelihood]="unlikely" and [Loss Given Occurrence]= "moderate","4 & 5", iif([likelihood]="unlikely" and [Loss Given Occurrence]= "major","6 & 7", iif([likelihood]="unlikely" and [Loss Given Occurrence]= "catastrophic","6 & 7", iif([likelihood]="Possible" and [Loss Given Occurrence]= "insignificant","4 & 5", iif([likelihood]="Possible" and [Loss Given Occurrence]= "minor","4 & 5", iif([likelihood]="Possible" and [Loss Given Occurrence]= "moderate","6 & 7", iif([likelihood]="Possible" and [Loss Given Occurrence]= "major","6 & 7", iif([likelihood]="Possible" and [Loss Given Occurrence]= "catastrophic","8 & 10","" )))))))))))))))

Can someone please help me how I can do this in a Form? I have a text box to bring the results back but when I copy this "iif" string into the form, it come back as your expression is too complex.

PLEASE help. QUITE DESPERATE..I am a new user too.

[Aj_old]

Hi! Welcome to TSG Forum!
try this one!

=IIf([likelihood]="rare",
   Iif([Loss Given Occurrence]="Insignificant" or [Loss Given Occurrence]= "minor","2 & 3", 
   iif([Loss Given Occurrence]= "moderate" or [Loss Given Occurrence]= "major","4 & 5", 
   iif([Loss Given Occurrence]= "Catastrophic","6 & 7",""))),
iif([likelihood]="unlikely", 
   iif([Loss Given Occurrence]= "insignificant","2 & 3", 
   iif([Loss Given Occurrence]= "minor" or [Loss Given Occurrence]= "moderate","4 & 5", 
   iif([Loss Given Occurrence]= "major" or [Loss Given Occurrence]= "catastrophic","6 & 7",""))),
iif([likelihood]="Possible",
   iif([Loss Given Occurrence]= "insignificant" or [Loss Given Occurrence]= "minor","4 & 5", 
   iif([Loss Given Occurrence]= "moderate" or [Loss Given Occurrence]= "major","6 & 7",
   iif([Loss Given Occurrence]= "catastrophic","8 & 10","" ))))))

Just remove line brakes !

[Amature User]

THanks for the syntax, it worked perfectly. The only problem I have now is it's not showing the results in my table.

Eg. in likelihood when I choose "Rare" and Loss Given Occurrence "Insignificant", the result come back as 2 & 3, which is great. But when I check my table, the 2 & 3 is not there. Why is that? it's not storing in the table. As I will need to do reporting, I need this to be save in the table.

Please help.

[Amature User]

Thanks for the code. It worked perfectly.

What i've done is placed the code in the Control Source of my text box in form. The problem I now face is when the Risk Grading come back, it does not save in my table. I know that it does not save in my table because I've changed the control source....but is there away that I can have this save into my table??

How can I have the result save in my table?

I hope this make sense.....