Hide duplicates and only count those records
Posted on 2001-06-14
I'm helping a user set up a report where he wants to hide the duplicates. That's no problem. The problem is he wants to count the records under each category, but he only wants to count those records that are unique. So in other words, if the Office Name "Taylor Service Center" appeared 3 times under a category, he only wants to display it once and count it once. How do I count only unique records??? We're using Access 97. If I have to use code, please be very specific, as I'm not a programmer. Thanks.