Recent content by LordNightwinter

Solved! SPI Color: IIf([Schedule Performance Index (SPI)]<"0.8","R",IIf([Schedule Performance Index (SPI)] Between "0.8" And "0.9","Y",IIf([Schedule Performance Index (SPI)]>="0.9","G",IIf([Schedule Performance Index (SPI)]>="1.1","B","W"))))

Okay so I got the expression to work save one issue. I can't figure out how to specify a range. I need the red area to be between 0.8 and 0.9 to end up Y and everything .9 and above to be G. Any thoughts? SPI Color: IIf([Schedule Performance Index (SPI)]<"0.8","R",IIf([Schedule Performance...

I still need help. I can't get this durn thing to work in a module or an expression. I'm having problems wrapping my head around why it won't work.

Fair enough. Yes, what I'm trying to do is read a column that would be anywhere from nothing to 1.1 or above. From that number I want another column to read one of the indicated colors. >.9 - =<1.1 would be Green, between .8 and .9 would be Yellow, anything below .8 is Red and anything above 1.1...

I'm trying to write an expression in access. The parameters are a little complex. Of course, since something is wrong in the code it always returns W in the column. SPI Color: IIf([Schedule Performance Index (SPI)]=">.9 or <=1.1","G",IIf([Schedule Performance Index...