Conditional Formatting

[Mark S via AccessMonster.com]

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?

Thanks in advance for any clues on this....

 

[fredg]

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?

Thanks in advance for any clues on this....

Try <.90 instead of <90%.

 

[Marshall Barton]

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?

try using the number insteaf of the percent. E.g. 90% is .9

 

[Mark S via AccessMonster.com]

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

[quoted text clipped - 8 lines]

etc. Is there something I am missing? Does Conditional Formatting not work on
calculated fields?

try using the number insteaf of the percent. E.g. 90% is .9

You are the best....this worked....thank you...

 

[Mark S via AccessMonster.com]

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

[quoted text clipped - 10 lines]

Thanks in advance for any clues on this....

Try <.90 instead of <90%.

This worked.....Thank you so much......you are the best!!!!