Highlight repeat records

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

This one has got me. Any idea's at all is much
appreciated. My problem is that in a database i have, it
is possile to have the same data listed a number of times
except for one column.
What i would like to do is hightlight to the user that the
matching lines are the same, even if its just a symbol at
the start of the line.

I do not want to group these items either, just highlight
them.

EXAMPLE
PLACE PLU QTY
* 100 25 5
250 18 4
* 100 25 2

If you require further info, please contact me.
Thanks
 
Create a totals query that groups by Place and PLU while counting Qty. Join
this query to the record source query of your report. You can display the
"*" where the CountOfQTY is greater than 1
=IIf(CountOfQty > 1, "*","")
 
Back
Top