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!
------------------------ Yahoo! Groups Sponsor --------------------~--> Home is just a click away. Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
