I have a form containing general client information (ex: name, address, etc) and a subform within that form which is filled out each time the client returns for a service. I am trying to create a query/report which gives the total number of clients that have come from each city in out county. However, if a client has come more than once (i.e. more than one subform is filled out for them) the information on the parent form (ex: city) is counted more than once. How sum the total number of people from a city w/o duplicates? Can I perhaps base it on a the unique client ID? Any help would be greatly appreciated. Thanks!