I am struggling with a way to create a query that will only count duplicate names once.
Example:
I am creating a database to count class registrations. In some instances I have one person taking two or three different classes, but I only want to count them once for reporting purposes.
Does anyone have a direction to steer me in on how to get this to work?
Thanks!!