This depends on the structure of your tables... Ideally the you should have 2 tables that hold the information as you have outlined them to be.
Client Information in Table 1 Subform Information in Table 2 If this is not the case (which is not the best data structure for your tables) then an application of the "DISTINCT" parameter might help you delineate out the information that you need. Granted this can be a bit tricky if its all in one table. My strongest recommendation is to bit the bullet and split the table into its essential elements. This way you have a strong product going forward. A temporary band-aid now will only mean an even more complicated band-aid later on... adinfinitum -- until a band-aid can no longer suffice and you have to bite an even bigger bullet, perhaps one that is, by then, to big to bite. --- Eileen Crump <[EMAIL PROTECTED]> wrote: > 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? > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> You can search right from your browser? It's easy and it's free. See how. http://us.click.yahoo.com/_7bhrC/NGxNAA/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/
