Help with If Statement

[zero3ree]

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.

[alcapps]

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

[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

[zero3ree]

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.