Report conditional formatting

[Guest]

How do I use Conditional Formatting to turn on a field on a report based
on another field? My report shows contracts within 90 days due to expire.
This is working fine. What I would like to do is, once the number of days
diff becomes a negative number (Contract Date Expired), I want to turn on
next to the record in the report CONTRACT EXPIRED. My field Number of Days
contains the value I wish to check (this comes from query doing a DateDiff).
The field I wish to make visible is a label named lblExpired. Please help me
with the right formula to make this work.

Thanks in advance

Kenny A.

 

[fredg]

How do I use Conditional Formatting to turn on a field on a report based
on another field? My report shows contracts within 90 days due to expire.
This is working fine. What I would like to do is, once the number of days
diff becomes a negative number (Contract Date Expired), I want to turn on
next to the record in the report CONTRACT EXPIRED. My field Number of Days
contains the value I wish to check (this comes from query doing a DateDiff).
The field I wish to make visible is a label named lblExpired. Please help me
with the right formula to make this work.

Thanks in advance

Kenny A.

Kenny,
You posted the identical question in the Reports newsgroup ton the 2nd
day of July, and it was answered.
If you don't check for replies, what's the point of posting.
If you didn't understand the reply, then you should re-post in the
same thread and let us know what you don't understand.

 

[Guest]

Fred,
Normally I get sent an email when a response is given. I did not receive
the email telling me a response was given, so I assumed no one respopnded to
it. I must have forgotten to check the checkbox to be notified when a
response is given. I am very sorry then for reposting in the general room. My
Bad sorry Thanks for letting me know about the response in the reports
section.

Kenny A.