asked on

Finding Duplicates

I have a report that lists, say, sales people. The report is grouped on State. I need to be able to highlight (change font colour to red) sales persons who may appear in different states.

It's easy when they are in the same state, since they are sorted on an ID number and so I can just do sometrhing like this:

If 
    Previous ({SalesTable.SalesID}) = {SalesTable.SalesID}
    Or
    Next ({SalesTable.SalesID}) = {SalesTable.SalesID}
Then
    crRed
Else
    crNoColor

Open in new window

However, that doesn't work if the sales person is listed in CA and NY.

Any ideas?

TIA

SOLUTION

printnix63

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Clif

ASKER

It would appear that this is effectively impossible.

Thanks for your help anyway.

James0628

I don't know where you get "effectively impossible". Arguably, it might be a bit difficult, if you're not familiar with the techniques involved, but it certainly seems possible. Of course if you don't want to pursue it (maybe the color change just isn't that important), that's your call. But I wouldn't call it "impossible".

James