Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    34

    Question Unanswered: Conditional Formatting

    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....

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Conditional formatting does work on calculated fields. However it may be formatted, 90% is actually .9, so try using that in your expression.
    Paul

  3. #3
    Join Date
    May 2004
    Posts
    34
    Thanks Paul...That worked. Isn't great that we of like industry can go to a place like dbforums and get help. Thank you again!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •