Expression Builder Help in Access

[Mike.Howard79]

Hi all,

I was wondering if I can build an expression which will show either "Exceeds", "Meets" or "Does not Meet" depending on the number in another field. I have used the iif function, can I nest multiple functions in an expression to do this.

Eg if [occurances] is 0, "Exceeds" but if [occurance] between 2 and 5, "meets" but [occurances] is more than 5,"Does not meet"?

Hope this makes sense

Thanks in advance

Mike

 

[littleiitin]

You can use like below

strStore = 10
Str = IIf(strStore < 10, "Does not Meet", IIf(strStore < 10, "Meets", "Exceeds"))

 

[Mike.Howard79]

Not sure what you were on about there sorry

 

[Mike.Howard79]

I have a field set up which will hold the amount of occurances of absence an employee has had however to keep the consistancy with performance and appraisals with the managers who are holding the meetings I would like an auto fill on the form which will mark the employee depending on the number of occurances ie. 0 is exceeds, 0 - 3 meets and more than 3 is does not meet.

Hope this helps

Mike