Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula to highlight duplicates
- Thread starter Abner2
- Start date
synapsevampire
Programmer
If you're sorted by the address, then you can use:
Use the previous({Table.Address}) = {Table.Address} in the formatting section of choice to highlight it.
Now you have to decide what highlighting means, does that mean a colorized background? If so, use:
Right click the field->Format Field->Border->X-2 next to Background:
if previous({Orders.Order Date}) = {Orders.Order Date} then
cryellow
else
crwhite
-k kai@informeddatadecisions.com
Use the previous({Table.Address}) = {Table.Address} in the formatting section of choice to highlight it.
Now you have to decide what highlighting means, does that mean a colorized background? If so, use:
Right click the field->Format Field->Border->X-2 next to Background:
if previous({Orders.Order Date}) = {Orders.Order Date} then
cryellow
else
crwhite
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question