Conditional Formatting

[Guest]

Is there an expression that can be used in the conditional formatting tool of
a specific data field in a Report that will identify multiple entries of the
same value?
In this particular report, I would like to highlight (change the background
color) of a particular data field when the same value pops up more than once
on the report. (the data field is a numerical ID that can sometimes pop up on
different days contained in the report) I thought there might be some
expression I could use in conditional formatting that would identify/single
out repeats of the same value in a particular report.

Report Example:
Date:04/11/05
LocCode MRN
150 999999
200 888888<--| Background color changes for both MRN fields as
value
116 777777 |displays again on 4/12.
Date:04/12/05 |
LocCode MRN |
130 222222 |
200 888888<--|
124 666666

Thanks in advance.

 

[Steve Schapel]

Antonio,

First of all, make a query that counts the number of occurrences of each
MRN in the report's existing record source. Get this query, and include
it in the query that you are currently using, joined on the MRN field,
and include the count field into the query design. Then you can refer
to this field in the Conditional Formatting expression, e.g.
[Occurrences]>1 to set a different colour for the MRN textbox.