Using Access 2000. When I use a simple query to get sum of calls taken and apply conditional formatting to show calls taken under, say 100 in red, my report/form shows calls taken < 100 in red.
When I create a query to get percent adherence and percent efficiency (sums) and then create another query from the totals of the previous query to get top gun scores (adherence+efficiency)/2 and apply conditional formatting to show red for those under 90% the conditional formatting doesn't work.
I have tried using quotes around the "90%". I've tried using under, between, etc. Is there something I am missing? Does Conditional Formatting not work on calculated fields?