Mike.Howard79
New Member
- Joined
- Feb 23, 2010
- Messages
- 21
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
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
