Hello All, I have a 7 drop downs that select from a table for a performance evaluations. the user selects from the drop down and each value in the drop down is calculated and divided by 7 =[txtSumOfAllNumber s]/7 I have another text field that I would like to have a corresponding message appear based on the value of the txtSumOfAllNumbers field. Below is my IIf statement. I cannot get it to work. The calculations have not been worked out based on the actual value that I need to base the message on. It would be something like IIf the value of the field is <=1.5, "fired", IIf the value of the field is >1.5 and <=2.5, "better", IIf the value of the field is >2.5 and <=3.78, "even better" and so on.
Here is what I have so far with just even numbers in the expression. The expression is on the forms control source. =IIf([txtAverageOfA llNumbers] <=1,"1 Fails to Meet Performance Expectations" ,IIf([txtAverage OfAllNumbers] >=1,"2 Inconsistently Fulfills Performance Expectations" ,IIf([txtAverage OfAllNumbers] >=2,"3 Performance Expectations Fulfilled",IIf( [txtAverageOfAll Numbers]> =3,"4Frequently Exceeds Performance Expectaitions" ,IIf([txtAverage OfAllNumbers] >=5,"5 Consistently Exceeds Performance Expectations" ))))) Jim Wagner
