Help with If Statement

I need to add to the if statements that provide a color for a status.

It needs to be red, yellow, or green depending on the percentage below or above the actual number is. I wrote this if statement but it doesn't like it.

TIME_STAT: IIf([TOT_EST]<=[ACT10PLUS]>=[ACT10MIN],"Green",IIf([TOT_EST]<[ACT20PLUS]>[ACT20MIN],"Yellow",IIf([TOT_EST]>[ACT20PLUS]<[ACT20MIN],"Red","Need Data")))



I am not sure how to do this in Access. Bottom line is that If the actual is in the range of 10% either way it can be green, within 20% it can be yellow, after that it is red. I put this formula in and it gave me all "Red" with the occasional "Need Data" on the blanks as my result. Any suggestions on a fix for my formula? It seems I need to have and or or between the greater or lesser but when I do that it errors.

Thanks in advance.

you can use conditional formatting. Lookup conditional formatting ms access on google.com and you will find out how to do this.

Hope this helps

TIME_STAT: IIf([TOT_EST]<=[ACT10PLUS] and [ACT10PLUS]>=[ACT10MIN],"Green",IIf([TOT_EST]<[ACT20PLUS] and [ACT20PLUS]>[ACT20MIN],"Yellow",IIf([TOT_EST]>[ACT20PLUS] and [ACT20PLUS]<[ACT20MIN],"Red","Need Data")))

if this doesn't give u the results u r looking for, mention the logic u r looking for and we'll help u with the function statement

Originally Posted by qa12dx

TIME_STAT: IIf([TOT_EST]<=[ACT10PLUS] and [ACT10PLUS]>=[ACT10MIN],"Green",IIf([TOT_EST]<[ACT20PLUS] and [ACT20PLUS]>[ACT20MIN],"Yellow",IIf([TOT_EST]>[ACT20PLUS] and [ACT20PLUS]<[ACT20MIN],"Red","Need Data")))

if this doesn't give u the results u r looking for, mention the logic u r looking for and we'll help u with the function statement

Wasn't quite what I needed but it got my solution. I was not addressing the "and" part of the statement correctly. This is what I needed to have.

TIME_STAT: IIf([TOT_EST]<=[ACT10PLUS] And [TOT_EST]>=[ACT10MIN],"Green",IIf([TOT_EST]<=[ACT20PLUS] And [TOT_EST]>=[ACT20MIN],"Yellow",IIf([TOT_EST]>[ACT20PLUS] Or [TOT_EST]<[ACT20MIN],"Red","Need Data")))

Thank you for your help. Now I can go on to building my case function.