Highlight Duplicates - one last thing

[Abner2]

It's working great except that the first address on the report and the last address on the report are highlighted even though neither address is duplcated. Any idea why or how to correct this?

Thanks again for all of your help!

 

[synapsevampire]

Add to the formula the onfirstrecord and onlastrecord checks.

So the formula would be something like:

if onfirstrecord then
if next({Orders.Order Date}) = {Orders.Order Date} then
cryellow
else
crwhite
else
if onlastrecord then
if previous({Orders.Order Date}) = {Orders.Order Date} then
cryellow
else
crwhite
else
if previous({Orders.Order Date}) = {Orders.Order Date}
or
next({Orders.Order Date}) = {Orders.Order Date}
then
cryellow
else
crwhite

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com