Conditional Formatting in a Report

[amguttman]

I am have created a report in Access 2000 file format that calculate
whether a due date is approaching, has been reached, or has passed.
I have set three formatting conditions depending on the fiel
value
The field value comes from the following data source
=([Start Date]+60)-Date(

Condition 1: Field Value is Between 60 and 11
(Formatting - Green Background

Condition 2: Field Value is Between 10-
(Formatting - Orange Background

Condition 3: Field Value is Less than or Equal to
(Formatting - Red Background

I am getting a green background regardless of the field value (i.e
when the field value meets conditions 2 or 3, I'm still getting th
Green Background formatting. I'm getting negative field value an
expecting a red background, but the field background is green.

What's going on

 

[Rick B]

Do you really have Between 60 and 11?

I would try reversing those. Between 11 and 60.

Same with one and ten

 

[amguttman]

I reversed the numbers per your suggestion, there is still no chang
to the formatting based on the values reported. Any othe
suggestions? Appreciate your help. Ala

 

[Meet Agrawal via AccessMonster.com]

I reversed the numbers per your suggestion, there is still no chang
to the formatting based on the values reported. Any othe
suggestions? Appreciate your help. Ala

I think that their is problem with your code,
try using debugging method by giving brekpoints in your code where
you are setting your background
If your code gets executed(changing background code), then it will reflect
your report