Duplicate record

I

Irshad Alam

HOW TO CHANGE THE COLOUR OF THE DUPLICATE RECORD ON THE
REPORT PREVIEW:
Example :
SeqNo Namee Time Date Points
1 Irshad 15.00 25-2-04 100
2 Alam 11.00 30-2-04 200
3 Mohammad 12.30 31-3-04 300
4 Irshad 15.00 25-2-04 400
5 Jim 17.30 26-3-04 352

Actually there are hudge lot of data posted previously,
which I have to make a report, on which the duplicate
record should be in different colour, as shown in example
record no.4 is a duplicate record. What code should I put
in the report event property, so that it can do the job
which as I want.
I am aware how to sort out the duplicate records with the
help of Query. But the situation here is little different,
that all records should be there and the duplicate ones
should only change a different colour.

Regards.
 
D

Duane Hookom

Make a query similar to your report's records source but make it into a
totals query that groups by all fields and counts a non-null field. Save
this query and add it to your report's record source query joining the
appropriate fields. This should allow you to add the Count of your non-null
field to the query and use it in the report. You can then use conditional
formatting with the expression CountOfNonNullField >1.
 
Top