I'm working on a report in SSRS and I'm getting too many results from my query. For instance, if I have User A enter who enters a service of PT on 8/30/15 for Sally and User B also enters a service of PT on 8/30/15 for Sally, I only want to count it once. Basically, for certain services, if the database sees more than one of the same service entered for the same day, I only want the query to return one record. Also, is it possible to have this same concept work but instead of the same service for the same day, I would like the query to return only one record if it sees more than one of the same service for a certain month. I hope this makes sense.