I have 2 simple rules on a text box control. If the value is >= 120% the text is formatted red, if the value is <= 80% the text box is formatted with blue shading. The values greater than 120% work fine, but the values less that 80% will not format as blue shading. In addition, both rules work fine with reports with this same conditional formatting that only have one query within the report query... it seems the reports where I have multiple queries within the report query is where I'm having a problem.
I have tried everything.
Any suggestions would be greatly appreciated.
Kind regards,
Marty