Setting up report with conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a report that will print records in a different color
if they don't meet certain criteria. The report shows all persons that are
eligible for a check on a given date. What I want to show in the report is
everybody that is eligible, but if their records are not up-to-date, I want
that record to appear RED on the report. So in other words, if there records
were due to be update by 7/1/2005 and were not, but they are eligble for a
check on 8/1/2005, I want that record to appear in RED on the report so I
know to notify them to get their records updated before issuing them the
check.

Hope this wasn't confusing.
 
Provided you are working with Access 2000 or later, you can do this with
Conditional Formatting (CF).

1. Open the report in design view.

2. Select the text box that should go red.

3. Choose CF on the Format menu.

4. Set Condition 1 to something like:
[Date1] < [Date2]
where Date1 and Date2 represent your date fields.
 
Back
Top