Re: Conditional Formatting



fredg wrote:
>> 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!!!!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200510/1
.



Relevant Pages

  • Conditional Formatting
    ... When I use a simple query to get sum of calls taken and ... When I create a query to get percent adherence and percent efficiency ... top gun scores /2 and apply conditional formatting to ... Thanks in advance for any clues on this.... ...
    (microsoft.public.access.queries)
  • Re: Conditional Formatting
    ... Marshall Barton wrote: ... 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 ...
    (microsoft.public.access.queries)
  • RE: Calculated fields in main form based on criteria in sub form
    ... Main form (goat survey table and Total queries) ... NE Sum Query (uses information from the subform, ... other queries differ in what Quadrant equals) ...
    (microsoft.public.access.forms)
  • RE: Calculated fields in main form based on criteria in sub form
    ... Main form (goat survey table and Total queries) ... NE Sum Query (uses information from the subform, ... other queries differ in what Quadrant equals) ...
    (microsoft.public.access.forms)
  • Re: conditional formatting in form slows down calculations
    ... > table to see all dates and a filtered query to see recent dates. ... If I set it to open with the record source the query, ... > endless calculating when the form opens. ... >> CF (Conditional Formatting) is a weird beast, ...
    (microsoft.public.access.forms)