Evening all.

Access 2000

I didnt' think my math was too bad but I'ms stuck in a rut with this
formating issue.

I have a field that is a basic sum of other fields shown below

=IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
Secs]))))/([Inbound Calls Answered]))

I'ts basicaly realtime data from a Telephone switch to show how fast calls
are answered

The current result in the field gives an answer of 0.0909090909090909 which
as a percentage is 9.09% using the percent format

Under conditional formating I have the following criteria

Condition 1
Field Value is - [less than or equal to] - 0.79 Colour the cell RED

Condition 2
Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN

Now at the moment the 0.90909 result is turning the cell Green, when it
should be red.

I've used the same data in Excel, with the same formating and it works
correctly?

Any idea's

What is the conditional formatting evaluating 0.09, 0.90, or 9.09?

LDN

"Steve B" wrote:

> Evening all.
>
> Access 2000
>
> I didnt' think my math was too bad but I'ms stuck in a rut with this
> formating issue.
>
> I have a field that is a basic sum of other fields shown below
>
> =IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
> Secs]))))/([Inbound Calls Answered]))
>
> I'ts basicaly realtime data from a Telephone switch to show how fast calls
> are answered
>
> The current result in the field gives an answer of 0.0909090909090909 which
> as a percentage is 9.09% using the percent format
>
> Under conditional formating I have the following criteria
>
> Condition 1
> Field Value is - [less than or equal to] - 0.79 Colour the cell RED
>
> Condition 2
> Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN
>
> Now at the moment the 0.90909 result is turning the cell Green, when it
> should be red.
>
> I've used the same data in Excel, with the same formating and it works
> correctly?
>
> Any idea's
>

It's evaluating >= .8 and <= .799


"roccogrand" <(E-Mail Removed)> wrote in message
news:E8948709-8F4E-4C51-A6BD-(E-Mail Removed)...
> What is the conditional formatting evaluating 0.09, 0.90, or 9.09?
>
> LDN
>
> "Steve B" wrote:
>
>> Evening all.
>>
>> Access 2000
>>
>> I didnt' think my math was too bad but I'ms stuck in a rut with this
>> formating issue.
>>
>> I have a field that is a basic sum of other fields shown below
>>
>> =IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
>> Secs]))))/([Inbound Calls Answered]))
>>
>> I'ts basicaly realtime data from a Telephone switch to show how fast
>> calls
>> are answered
>>
>> The current result in the field gives an answer of 0.0909090909090909
>> which
>> as a percentage is 9.09% using the percent format
>>
>> Under conditional formating I have the following criteria
>>
>> Condition 1
>> Field Value is - [less than or equal to] - 0.79 Colour the cell RED
>>
>> Condition 2
>> Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN
>>
>> Now at the moment the 0.90909 result is turning the cell Green, when it
>> should be red.
>>
>> I've used the same data in Excel, with the same formating and it works
>> correctly?
>>
>> Any idea's
>>