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!!!!
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: 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)