Hiya All :)

We have a table that holds four (or five) previous addresses for people (as well as their current address).

I need a way of comparing all 4 or 5 records and highlighting which ones are the same.

Example:
14 Cromby Street, JM8 7BH
28 Mills Road, KD5 8HC
9 Oban Drive, G56 734
28 Mills Road, KD5 8HC
17 Johns Road, KG6 5FG

I need it to highlight the 2nd and fourth records as being the same address.

I tried using next/ previous but that limits me to just the records next to one another.

Is there another way to do it?

Cheers,
Q