Finding duplicate records in a report

[sjassal]

Hello,

I am not sure if this is possible but if it is any help or suggestions will be greatly appreciated.

Lets say I have a record that falls in 2 or more categories. I would like to mark (change the font color) for the repeating entires. For example:

Table A

code name value
X Sample X value X
Y Sample Y value Y
Z Sample Z value Z
B Sample B value B


Table B
code region
X Region D
X Region E
X Region F
Y Region D
Y Region G
Z Region D
Z Region F
B Region F

Report will be grouped by Region and should look like the follows (Please note that duplicate data should appear in blue):

Region D
Sample X Value X
Sample Y Value Y
Sample Z Value Z

Region E
Sample X Value X

Region F
Sample X Value X
Sample Z Value Z

Region G
Sample Y Value Y
Sample B Value B



Any help will be greatly appreciated.

Thanks.

 

[Brad]

Are you using a query to generate your report data ? If so then simply count the records before you group them and set colour to work on count.

ie is count is 1 then black, if >1 then blue.